PI_RTV_LOC3_VW

(SQL View)
Index Back

Express Issue Physical View


SELECT pi.business_unit , pi.staged_date , pi.inv_lot_id , pi.serial_id , pi.inv_item_id , pi.storage_area , pi.stor_level_1 , pi.stor_level_2 , pi.stor_level_3 , pi.stor_level_4 , pi.container_id , pi.unit_of_measure , pi.qty - pi.qty_reserved , pi.qty_base - pi.qty_reserved_base , pi.avail_status FROM PS_PHYSICAL_INV pi WHERE pi. qty > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 STAGED_DATE Date(10) DATE NOT NULL Staged Date

Default Value: %Date

3 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

4 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_PRPT_VW

6 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: STOR_AREA_VW

7 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: STOR_LEV1_VW

8 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: STOR_LEV2_VW

9 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: STOR_LEV3_VW

10 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: STOR_LEV4_VW

11 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
12 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: INV_STCK_UOM_VW

13 QTY_AVAILABLE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Available
14 QTY_AVAILABLE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Available
15 AVAIL_STATUS Character(1) VARCHAR2(1) NOT NULL Availability Status
1=Open
2=Restricted
3=Hold
4=Rejected

Default Value: 1