DBA Data[Home] [Help]

APPS.WIP_EXPLODE_PHANTOM_RTGS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 21: from mtl_material_transactions_temp mmtt,

17: BEGIN
18: --bug 5231366
19: select mp.organization_code
20: into l_org_code
21: from mtl_material_transactions_temp mmtt,
22: mtl_parameters mp
23: where mmtt.transaction_temp_id = p_txn_temp_id
24: and mmtt.organization_id = mp.organization_id;
25:

Line 161: mtl_material_transactions_temp MMTT

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
164: AND MMTT.inventory_item_id = p_phantom_item_id
165: AND MMTT.organization_id = p_org_id

Line 219: from mtl_material_transactions_temp mmtt,

215: Begin
216: --bug 5231366
217: select mp.organization_code
218: into l_org_code
219: from mtl_material_transactions_temp mmtt,
220: mtl_parameters mp
221: where mmtt.transaction_temp_id = p_txn_temp_id
222: and mmtt.organization_id = mp.organization_id;
223:

Line 345: mtl_material_transactions_temp mmtt

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
347: MMTT.transaction_temp_id = p_txn_temp_id
348: AND MMTT.transaction_source_id = wfs.wip_entity_id
349: AND MMTT.organization_id = wfs.organization_Id

Line 384: from mtl_material_transactions_temp mmtt,

380: Begin
381: --bug 5231366
382: select mp.organization_code
383: into l_org_code
384: from mtl_material_transactions_temp mmtt,
385: mtl_parameters mp
386: where mmtt.transaction_temp_id = p_txn_temp_id
387: and mmtt.organization_id = mp.organization_id;
388:

Line 514: mtl_material_transactions_temp mmtt

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
516: MMTT.transaction_temp_id = p_txn_temp_id
517: AND MMTT.transaction_source_id = wfs.wip_entity_id
518: AND MMTT.organization_id = wfs.organization_Id