DBA Data[Home] [Help]

APPS.WIP_SO_RESERVATIONS dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1449: MTL_TRANSACTION_LOTS_TEMP MTLT,

1445: mtlt.lot_expiration_date,
1446: mmtt.transaction_temp_id,
1447: null --never an lpn associated with a non-lpn completion
1448: FROM MTL_SYSTEM_ITEMS MSI,
1449: MTL_TRANSACTION_LOTS_TEMP MTLT,
1450: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1451: WHERE mmtt.completion_transaction_id = cp_transaction_header_id
1452: AND mmtt.transaction_action_id = cp_transaction_action_id
1453: AND mmtt.transaction_source_type_id = 5 /* Job or Schedule */