APPS.WIP_MOVE_VALIDATOR dependencies on WIP_MOVE_TRANSACTIONS

Line 1539: -- validate transaction_id against the one in WIP_MOVE_TRANSACTIONS, and

1535: p_err_msg => fnd_message.get);
1536:
1537: END ocpl_txn_qty;
1538:
1539: -- validate transaction_id against the one in WIP_MOVE_TRANSACTIONS, and
1540: -- WIP_MOVE_TXN_INTERFACE. This value need to be unique.
1541: PROCEDURE transaction_id IS
1542: l_errMsg VARCHAR2(240);
1543: BEGIN

Line 1589: FROM wip_move_transactions wmt

1585: AND wmti1.process_phase = WIP_CONSTANTS.MOVE_VAL
1586: AND wmti1.process_status = WIP_CONSTANTS.RUNNING
1587: AND (EXISTS
1588: (SELECT 'X'
1589: FROM wip_move_transactions wmt
1590: WHERE wmt.transaction_id = wmti1.transaction_id)
1591: OR
1592: (1 <>
1593: (SELECT count(*)

Line 3102: from wip_move_transactions

3098: select organization_id,
3099: wip_entity_id
3100: into l_org_id,
3101: l_wip_entity_id
3102: from wip_move_transactions
3103: where transaction_id = p_move_id;
3104: end if;
3105:
3106: if (l_assm_item_id is NULL) then