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 5400: BOM_DEPARTMENTS BD

5396: p_program_id,
5397: DECODE(p_program_id, 0, '', SYSDATE),
5398: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
5399: FROM WIP_OPERATIONS WO,
5400: BOM_DEPARTMENTS BD
5401: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
5402: AND WO.OPERATION_SEQ_NUM = l_op_seq_incr
5403: AND WO.DEPARTMENT_ID = BD.DEPARTMENT_ID;
5404: