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 |