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 2087: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),

2083:
2084: --make sure the completions have a cpl id and batch id
2085: --make sure overcompletions have a move id and overcpl id.
2086: update mtl_transactions_interface
2087: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),
2088: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),
2089: transaction_batch_seq = nvl(transaction_batch_seq, wip_constants.ASSY_BATCH_SEQ),
2090: overcompletion_transaction_id = nvl(overcompletion_transaction_id, decode(overcompletion_transaction_qty,
2091: null, overcompletion_transaction_id,

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

2084: --make sure the completions have a cpl id and batch id
2085: --make sure overcompletions have a move id and overcpl id.
2086: update mtl_transactions_interface
2087: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),
2088: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),
2089: transaction_batch_seq = nvl(transaction_batch_seq, wip_constants.ASSY_BATCH_SEQ),
2090: overcompletion_transaction_id = nvl(overcompletion_transaction_id, decode(overcompletion_transaction_qty,
2091: null, overcompletion_transaction_id,
2092: wip_transactions_s.nextval)),

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

2098: and transaction_source_type_id = 5;
2099:
2100: --make sure flow scrap transactions have a cpl id and batch id
2101: update mtl_transactions_interface
2102: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),
2103: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),
2104: transaction_batch_seq = nvl(transaction_batch_seq, wip_constants.ASSY_BATCH_SEQ)
2105: where transaction_header_id = p_txnHeaderID
2106: and transaction_action_id = wip_constants.scrassy_action

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

2099:
2100: --make sure flow scrap transactions have a cpl id and batch id
2101: update mtl_transactions_interface
2102: set completion_transaction_id = nvl(completion_transaction_id, mtl_material_transactions_s.nextval),
2103: transaction_batch_id = nvl(transaction_batch_id, nvl(completion_transaction_id, mtl_material_transactions_s.nextval)),
2104: transaction_batch_seq = nvl(transaction_batch_seq, wip_constants.ASSY_BATCH_SEQ)
2105: where transaction_header_id = p_txnHeaderID
2106: and transaction_action_id = wip_constants.scrassy_action
2107: and upper(nvl(flow_schedule, 'N')) = 'Y'