DBA Data[Home] [Help]

APPS.WIP_MTI_PUB dependencies on WIP_TRANSACTIONS_S

Line 2141: wip_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)),
2142: move_transaction_id = nvl(move_transaction_id, decode(overcompletion_transaction_qty,
2143: null, move_transaction_id,
2144: wip_transactions_s.nextval))
2145: where transaction_header_id = p_txnHeaderID

Line 2144: wip_transactions_s.nextval))

2140: null, overcompletion_transaction_id,
2141: wip_transactions_s.nextval)),
2142: move_transaction_id = nvl(move_transaction_id, decode(overcompletion_transaction_qty,
2143: null, move_transaction_id,
2144: wip_transactions_s.nextval))
2145: where transaction_header_id = p_txnHeaderID
2146: and transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)
2147: and transaction_source_type_id = 5;
2148: