DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on BOM_DEPARTMENTS

Line 384: BOM_DEPARTMENTS BD

380: BOS.original_system_reference,
381: BOS.lowest_acceptable_yield --mes
382: FROM BOM_OPERATION_SEQUENCES BOS,
383: BOM_STANDARD_OPERATIONS BSO,
384: BOM_DEPARTMENTS BD
385: WHERE BOS.routing_sequence_id = p_common_rtg_seq_id
386: AND p_rtg_rev_date between BOS.effectivity_date and nvl(BOS.disable_date, p_rtg_rev_date+1)
387: AND BOS.standard_operation_id = BSO.standard_operation_id (+)
388: AND BOS.department_id = BD.department_id;

Line 5631: BOM_DEPARTMENTS BD

5627: p_program_id,
5628: DECODE(p_program_id, 0, '', SYSDATE),
5629: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
5630: FROM WIP_OPERATIONS WO,
5631: BOM_DEPARTMENTS BD
5632: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
5633: AND WO.OPERATION_SEQ_NUM = l_op_seq_incr
5634: AND WO.DEPARTMENT_ID = BD.DEPARTMENT_ID;
5635: