SF_SRH_OP_LVW1(SQL View) |
Index Back |
---|---|
OPMtnce:View by PIDkey-RL View02/18/98: Saritha: Created. Required as related Language record for view 'SF_SRH_OP_VW1' 12/18/98 lee 8.0 enhancement force rank 1785. Sort by PID in descending order. 07/06/99 RT CN#MG800-4.0 Changed prompt table for inv_item_id |
SELECT b.business_unit , b.production_id , b.prdn_area_code , b.inv_item_id , c.language_cd , c.descr FROM PS_SF_PRDNID_HEADR b , PS_MASTER_ITM_LANG c , PS_SET_CNTRL_REC d WHERE b.ma_prdn_id_flg = 'Y' AND (b.prod_status = '20' OR b.prod_status = '15' OR (b.prod_status = '30' AND NOT ((b.completed_qty + b.scrap_qty) > 0 AND NOT EXISTS ( SELECT h.production_id FROM PS_SF_OP_LIST h WHERE h.business_unit = b.business_unit AND h.production_id = b.production_id))) ) AND d.recname = 'MASTER_ITEM_TBL' AND d.setcntrlvalue = b.business_unit AND c.setid=d.setid AND c.inv_item_id=b.inv_item_id |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
2 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
3 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_LVW7 |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |