123: BOM_DEPARTMENTS BD,
124: BOM_RESOURCES BR,
125: CST_ACTIVITIES CA,
126: BOM_OPERATION_SEQUENCES BOS,
127: wip_lpn_completions wlc,
128: bom_operational_routings bop
129: WHERE
130: wlc.header_id = p_header_id
131: AND wlc.organization_id = bd.organization_id
300: wlc.ITEM_TASK_ID
301: FROM
302: BOM_DEPARTMENTS bd,
303: BOM_OPERATION_SEQUENCES bos,
304: wip_lpn_completions wlc,
305: bom_operational_routings bop
306: WHERE
307: WLC.header_id = p_header_id
308: AND wlc.organization_id = bd.organization_id
444: wlc.item_task_id
445: FROM
446: BOM_DEPARTMENTS bd,
447: BOM_OPERATION_SEQUENCES bos,
448: wip_lpn_completions wlc,
449: bom_operational_routings bop
450: WHERE
451: WLC.header_id = p_header_id
452: AND wlc.organization_id = bd.organization_id
485: BEGIN
486: BEGIN
487: SELECT repetitive_line_id
488: INTO l_repLineId
489: FROM wip_lpn_completions
490: WHERE header_id = p_header_id;
491:
492: EXCEPTION
493: when others then