DBA Data[Home] [Help]

APPS.WIP_REBUILD dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 72: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,

68: to_number(meaa.priority_code),
69: meaa.owning_department_id,
70: meaa.tagging_required_flag,
71: to_number(meaa.shutdown_type_code)
72: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
73: mtl_system_items msi,
74: mtl_eam_asset_activities meaa
75: WHERE transaction_temp_id = p_tempId
76: and mmtt.rebuild_activity_id = msi.inventory_item_id (+)

Line 115: from mtl_material_transactions_temp mmtt,

111: l_orgID,
112: l_txnDate,
113: l_assetNum,
114: l_assetGrpID
115: from mtl_material_transactions_temp mmtt,
116: wip_discrete_jobs wdj
117: where wdj.wip_entity_id = mmtt.transaction_source_id
118: and mmtt.transaction_temp_id = p_tempId;
119:

Line 202: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,

198: to_number(meaa.priority_code) as priority_code,
199: meaa.owning_department_id,
200: tagging_required_flag,
201: to_number(shutdown_type_code) as shutdown_type_code
202: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
203: mtl_serial_numbers msn,
204: mtl_system_items msi,
205: mtl_eam_asset_activities meaa
206: WHERE transaction_temp_id = p_tempId