APPS.WIP_FLOW_CHARGE_UTILITIES dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 159: mtl_material_transactions_temp MMTT,

155: BOM_RESOURCES BR,
156: CST_ACTIVITIES CA,
157: BOM_OPERATION_SEQUENCES BOS,
158: -- BOM_OPERATIONAL_ROUTINGS ROUT,
159: mtl_material_transactions_temp MMTT,
160: mtl_parameters mp
161: WHERE
162: MMTT.transaction_temp_id = p_txn_temp_id
163: AND MMTT.inventory_item_id = wfs.primary_item_id

Line 397: mtl_material_transactions_temp mmtt,

393: BOM_DEPARTMENTS bd,
394: BOM_OPERATION_SEQUENCES bos,
395: WIP_FLOW_SCHEDULES wfs,
396: -- BOM_OPERATIONAL_ROUTINGS BOR,
397: mtl_material_transactions_temp mmtt,
398: mtl_parameters mp
399: WHERE
400: MMTT.transaction_temp_id = p_txn_temp_id
401: AND MMTT.transaction_source_id = wfs.wip_entity_id

Line 577: mtl_material_transactions_temp mmtt,

573: BOM_DEPARTMENTS bd,
574: BOM_OPERATION_SEQUENCES bos,
575: WIP_flow_schedules wfs,
576: -- BOM_OPERATIONAL_ROUTINGS BOR,
577: mtl_material_transactions_temp mmtt,
578: mtl_parameters mp
579: WHERE
580: MMTT.transaction_temp_id = p_txn_temp_id
581: AND MMTT.transaction_source_id = wfs.wip_entity_id

Line 643: FROM mtl_material_transactions_temp

639: CURSOR Flow_Completion (header_id number) is
640: SELECT completion_transaction_id,
641: transaction_temp_id,
642: repetitive_line_id
643: FROM mtl_material_transactions_temp
644: WHERE transaction_header_id = header_id
645: AND transaction_source_type_id = 5
646: AND UPPER(NVL(flow_schedule,'N')) = 'Y'
647: AND transaction_action_id in (31, 32, 30)-- CFM Scrap

Line 662: FROM mtl_material_transactions_temp mmtt,

658: mmtt.operation_seq_num*(-1) operation_seq_num,
659: mmtt.completion_transaction_id,
660: mmtt.transaction_temp_id,
661: mmtt.repetitive_line_id
662: FROM mtl_material_transactions_temp mmtt,
663: wip_flow_schedules wfs,
664: bom_operational_routings bor,
665: bom_operation_sequences bos
666: WHERE

Line 701: FROM mtl_material_transactions_temp mmtt,

697: mmtt.operation_seq_num*(-1) operation_seq_num,
698: mmtt.completion_transaction_id,
699: mmtt.transaction_temp_id,
700: mmtt.repetitive_line_id
701: FROM mtl_material_transactions_temp mmtt,
702: wip_flow_schedules wfs,
703: bom_operational_routings bor,
704: bom_operation_sequences bos
705: WHERE

Line 777: FROM mtl_material_transactions_temp

773:
774: /* phantom costing */
775: SELECT organization_id
776: INTO x_org_id
777: FROM mtl_material_transactions_temp
778: WHERE transaction_header_id = p_header_id
779: AND rownum = 1;
780:
781: IF (wip_globals.USE_PHANTOM_ROUTINGS(x_org_id) = WIP_CONSTANTS.YES) THEN

Line 800: delete mtl_material_transactions_temp

796: end if;
797: END LOOP;
798:
799: /* delete phantoms from MMTT before moved to MMT */
800: delete mtl_material_transactions_temp
801: where
802: transaction_header_id = p_header_id
803: AND transaction_source_type_id = 5
804: AND UPPER(NVL(flow_schedule,'N')) = 'Y'