APPS.WIP_EXPLODE_PHANTOM_RTGS dependencies on BOM_OPERATION_SEQUENCES

Line 159: BOM_OPERATION_SEQUENCES BOS,

155: WIP_FLOW_SCHEDULES wfs,
156: BOM_DEPARTMENTS BD,
157: BOM_RESOURCES BR,
158: CST_ACTIVITIES CA,
159: BOM_OPERATION_SEQUENCES BOS,
160: BOM_OPERATIONAL_ROUTINGS ROUT,
161: mtl_material_transactions_temp MMTT
162: WHERE
163: MMTT.transaction_temp_id = p_txn_temp_id

Line 342: BOM_OPERATION_SEQUENCES bos,

338: wfs.TASK_ID,
339: 1
340: FROM
341: BOM_DEPARTMENTS bd,
342: BOM_OPERATION_SEQUENCES bos,
343: WIP_FLOW_SCHEDULES wfs,
344: BOM_OPERATIONAL_ROUTINGS BOR,
345: mtl_material_transactions_temp mmtt
346: WHERE

Line 511: BOM_OPERATION_SEQUENCES bos,

507: wfs.TASK_ID,
508: 1
509: FROM
510: BOM_DEPARTMENTS bd,
511: BOM_OPERATION_SEQUENCES bos,
512: WIP_flow_schedules wfs,
513: BOM_OPERATIONAL_ROUTINGS BOR,
514: mtl_material_transactions_temp mmtt
515: WHERE

Line 614: BOM_OPERATION_SEQUENCES BOS,

610: BOM_RESOURCES BR,
611: BOM_OPERATION_RESOURCES BOR,
612: BOM_DEPARTMENT_RESOURCES BDR1,
613: BOM_DEPARTMENT_RESOURCES BDR2,
614: BOM_OPERATION_SEQUENCES BOS,
615: BOM_OPERATIONAL_ROUTINGS BRTG,
616: MTL_SYSTEM_ITEMS msi
617: WHERE
618: BRTG.organization_id = p_org_id

Line 644: FROM BOM_OPERATIONAL_ROUTINGS BOR,BOM_OPERATION_SEQUENCES BOS

640:
641:
642: CURSOR c_explodephantom IS
643: SELECT bos.operation_sequence_id
644: FROM BOM_OPERATIONAL_ROUTINGS BOR,BOM_OPERATION_SEQUENCES BOS
645: WHERE bor.organization_id=p_org_id
646: AND bor.assembly_item_id= p_phantom_item_id
647: AND bos.routing_sequence_id=bor.routing_sequence_id
648: AND bor.alternate_routing_designator IS NULL

Line 652: AND fad.entity_name = 'BOM_OPERATION_SEQUENCES' );

648: AND bor.alternate_routing_designator IS NULL
649: AND EXISTS (SELECT 1 FROM
650: FND_ATTACHED_DOCUMENTS fad
651: WHERE fad.pk1_value = TO_CHAR(bos.operation_sequence_id)
652: AND fad.entity_name = 'BOM_OPERATION_SEQUENCES' );
653: BEGIN
654:
655:
656: /* -------------------------------------------------------------*

Line 815: x_from_entity_name => 'BOM_OPERATION_SEQUENCES',

811:
812: END LOOP;
813: FOR op_attach IN c_explodephantom LOOP
814: fnd_attached_documents2_pkg.copy_attachments(
815: x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
816: x_from_pk1_value => to_char(op_attach.operation_sequence_id),
817: x_to_entity_name => 'WIP_DISCRETE_OPERATIONS',
818: x_to_pk1_value => to_char(p_wip_entity_id),
819: x_to_pk2_value => to_char(p_op_seq_num),