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:
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
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:
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
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:
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