DBA Data[Home] [Help]

APPS.PJM_COMMITMENT_UTILS dependencies on BOM_DEPARTMENTS

Line 89: , BOM_DEPARTMENTS BD

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
93: AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID;

Line 162: , BOM_DEPARTMENTS BD

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
166: AND WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID