DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on BOM_DEPARTMENTS

Line 807: BOM_DEPARTMENTS BD

803: l_stat_num := 40.1;
804: SELECT BD.DEPARTMENT_ID, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
805: into l_dept_id, l_scrap_account, l_est_absorption_account
806: FROM WIP_OPERATIONS WO,
807: BOM_DEPARTMENTS BD
808: WHERE WO.WIP_ENTITY_ID = x_wip_entity_id
809: AND WO.OPERATION_SEQ_NUM = x_to_op
810: AND WO.ORGANIZATION_ID = x_organization_id
811: AND WO.DEPARTMENT_ID = BD.DEPARTMENT_ID;

Line 1418: BOM_DEPARTMENTS BD

1414: WO.PROGRAM_APPLICATION_ID, WO.PROGRAM_ID, WO.PROGRAM_UPDATE_DATE,
1415: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
1416: FROM WIP_OPERATIONS WO,
1417: -- BOM_OPERATION_SEQUENCES BOS, fix bug 1611094
1418: BOM_DEPARTMENTS BD
1419: WHERE WO.WIP_ENTITY_ID = X_Wip_Entity_Id
1420: AND WO.OPERATION_SEQ_NUM = X_op_seq_num
1421: AND WO.ORGANIZATION_ID = X_Organization_Id
1422: -- AND WO.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID --bugfix 1611094

Line 2417: BOM_DEPARTMENTS BD

2413: DECODE(p_commit, 1, p_program_id, -999),
2414: DECODE(p_program_id, 0, '', SYSDATE),
2415: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
2416: FROM WIP_OPERATIONS WO,
2417: BOM_DEPARTMENTS BD
2418: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
2419: AND WO.OPERATION_SEQ_NUM = p_to_job_op_seq_num
2420: AND WO.ORGANIZATION_ID = p_org_id
2421: AND WO.DEPARTMENT_ID = BD.DEPARTMENT_ID; --bugfix 1611094