APPS.WIP_FLOWRESCHARGE dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 143: mtl_material_transactions_temp mmtt

139: l_toOpSeqNum,
140: l_parentTxnActionID,
141: l_orgID
142: from bom_operational_routings bor,
143: mtl_material_transactions_temp mmtt
144: where bor.assembly_item_id = mmtt.inventory_item_id
145: and bor.organization_id = mmtt.organization_id
146: and nvl(bor.alternate_routing_designator, 'NONE') =
147: nvl(mmtt.alternate_routing_designator, 'NONE')

Line 159: from mtl_material_transactions_temp

155: select organization_id,
156: nvl(routing_revision_date, sysdate)
157: into l_orgID,
158: l_effDate
159: from mtl_material_transactions_temp
160: where transaction_temp_id = p_txnTempID;
161:
162: chargePhantomResource(p_txnTempID, l_orgID, l_effDate, false, x_returnStatus);
163:

Line 229: from mtl_material_transactions_temp mmtt,

225:
226: --bug 5231366
227: select mp.organization_code
228: into l_org_code
229: from mtl_material_transactions_temp mmtt,
230: mtl_parameters mp
231: where mmtt.transaction_temp_id = p_txnTempID
232: and mmtt.organization_id = mp.organization_id;
233:

Line 350: mtl_material_transactions_temp mmtt

346: wip_flow_schedules wfs,
347: bom_departments bd,
348: bom_resources br,
349: bom_operation_sequences bos,
350: mtl_material_transactions_temp mmtt
351: where bos.operation_sequence_id =
352: l_chargeTbl(l_count).operation_sequence_id
353: and mmtt.transaction_temp_id = p_txnTempID
354: and bor.operation_sequence_id = bos.operation_sequence_id

Line 493: mtl_material_transactions_temp mmtt

489: from
490: bom_departments bd,
491: bom_operation_sequences bos,
492: wip_flow_schedules wfs,
493: mtl_material_transactions_temp mmtt
494: where bos.operation_sequence_id =
495: l_chargeTbl(l_count).operation_sequence_id
496: and mmtt.transaction_temp_id = p_txnTempID
497: and bd.organization_id = mmtt.organization_id

Line 594: mtl_material_transactions_temp mmtt

590: from
591: bom_departments bd,
592: bom_operation_sequences bos,
593: wip_flow_schedules wfs,
594: mtl_material_transactions_temp mmtt
595: where bos.operation_sequence_id =
596: l_chargeTbl(l_count).operation_sequence_id
597: and mmtt.transaction_temp_id = p_txnTempID
598: and wfs.organization_id = mmtt.organization_id

Line 650: from mtl_material_transactions_temp mmtt,

646: mmtt.operation_seq_num*(-1) operation_seq_num,
647: mmtt.transaction_temp_id,
648: mmtt.completion_transaction_id,
649: mmtt.repetitive_line_id
650: from mtl_material_transactions_temp mmtt,
651: wip_flow_schedules wfs,
652: bom_operational_routings bor,
653: bom_operation_sequences bos
654: where mmtt.completion_transaction_id =

Line 656: from mtl_material_transactions_temp mmtt2

652: bom_operational_routings bor,
653: bom_operation_sequences bos
654: where mmtt.completion_transaction_id =
655: (select mmtt2.completion_transaction_id
656: from mtl_material_transactions_temp mmtt2
657: where mmtt2.transaction_temp_id = p_txnTempID)
658: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
659: WIP_CONSTANTS.RETCOMP_ACTION,
660: WIP_CONSTANTS.ISSNEGC_ACTION,

Line 685: from mtl_material_transactions_temp mmtt

681: mmtt.operation_seq_num*(-1) operation_seq_num,
682: mmtt.transaction_temp_id,
683: mmtt.completion_transaction_id,
684: mmtt.repetitive_line_id
685: from mtl_material_transactions_temp mmtt
686: where mmtt.completion_transaction_id =
687: (select mmtt2.completion_transaction_id
688: from mtl_material_transactions_temp mmtt2
689: where mmtt2.transaction_temp_id = p_txnTempID)

Line 688: from mtl_material_transactions_temp mmtt2

684: mmtt.repetitive_line_id
685: from mtl_material_transactions_temp mmtt
686: where mmtt.completion_transaction_id =
687: (select mmtt2.completion_transaction_id
688: from mtl_material_transactions_temp mmtt2
689: where mmtt2.transaction_temp_id = p_txnTempID)
690: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
691: WIP_CONSTANTS.RETCOMP_ACTION,
692: WIP_CONSTANTS.ISSNEGC_ACTION,