DBA Data[Home] [Help]

APPS.PJM_COMMITMENT_UTILS dependencies on WIP_OPERATIONS

Line 88: from WIP_OPERATIONS WO

84: IF (X_dest = 'INVENTORY') THEN
85: L_Exp_Org := X_org;
86: ELSIF (X_dest = 'SHOP FLOOR') THEN
87: select BD.PA_EXPENDITURE_ORG_ID into L_Exp_Org
88: from WIP_OPERATIONS WO
89: , BOM_DEPARTMENTS BD
90: where WO.ORGANIZATION_ID = X_org
91: AND WO.WIP_ENTITY_ID = X_entity
92: AND WO.OPERATION_SEQ_NUM = X_seq

Line 161: , WIP_OPERATIONS WO

157: , WDJ.PRIMARY_ITEM_ID
158: , WO.DEPARTMENT_ID
159: into L_op, L_entity, L_item, L_dep
160: from WIP_DISCRETE_JOBS WDJ
161: , WIP_OPERATIONS WO
162: , BOM_DEPARTMENTS BD
163: where WDJ.ORGANIZATION_ID = X_org
164: AND WDJ.WIP_ENTITY_ID = X_entity
165: AND WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID