eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_MTI_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2136: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),

2132:
2133: --make sure the completions have a cpl id and batch id
2134: --make sure overcompletions have a move id and overcpl id.
2135: update mtl_transactions_interface
2136: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),
2137: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),
2138: transaction_batch_seq = nvl(transaction_batch_seq, wip_constants.ASSY_BATCH_SEQ),
2139: overcompletion_transaction_id = nvl(overcompletion_transaction_id, decode(overcompletion_transaction_qty,
2140: null, overcompletion_transaction_id,

Line 2137: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),

2133: --make sure the completions have a cpl id and batch id
2134: --make sure overcompletions have a move id and overcpl id.
2135: update mtl_transactions_interface
2136: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),
2137: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),
2138: transaction_batch_seq = nvl(transaction_batch_seq, wip_constants.ASSY_BATCH_SEQ),
2139: overcompletion_transaction_id = nvl(overcompletion_transaction_id, decode(overcompletion_transaction_qty,
2140: null, overcompletion_transaction_id,
2141: wip_transactions_s.nextval)),

Line 2151: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),

2147: and transaction_source_type_id = 5;
2148:
2149: --make sure flow scrap transactions have a cpl id and batch id
2150: update mtl_transactions_interface
2151: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),
2152: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),
2153: transaction_batch_seq = nvl(transaction_batch_seq, wip_constants.ASSY_BATCH_SEQ)
2154: where transaction_header_id = p_txnHeaderID
2155: and transaction_action_id = wip_constants.scrassy_action

Line 2152: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),

2148:
2149: --make sure flow scrap transactions have a cpl id and batch id
2150: update mtl_transactions_interface
2151: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),
2152: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),
2153: transaction_batch_seq = nvl(transaction_batch_seq, wip_constants.ASSY_BATCH_SEQ)
2154: where transaction_header_id = p_txnHeaderID
2155: and transaction_action_id = wip_constants.scrassy_action
2156: and upper(nvl(flow_schedule, 'N')) = 'Y'