APPS.WIP_MOVE_VALIDATOR dependencies on WIP_MOVE_TRANSACTIONS

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

1467: p_err_msg => fnd_message.get);
1468:
1469: END ocpl_txn_qty;
1470:
1471: -- validate transaction_id against the one in WIP_MOVE_TRANSACTIONS, and
1472: -- WIP_MOVE_TXN_INTERFACE. This value need to be unique.
1473: PROCEDURE transaction_id IS
1474: l_errMsg VARCHAR2(240);
1475: BEGIN

Line 1521: FROM wip_move_transactions wmt

1517: AND wmti1.process_phase = WIP_CONSTANTS.MOVE_VAL
1518: AND wmti1.process_status = WIP_CONSTANTS.RUNNING
1519: AND (EXISTS
1520: (SELECT 'X'
1521: FROM wip_move_transactions wmt
1522: WHERE wmt.transaction_id = wmti1.transaction_id)
1523: OR
1524: (1 <>
1525: (SELECT count(*)

Line 3034: from wip_move_transactions

3030: select organization_id,
3031: wip_entity_id
3032: into l_org_id,
3033: l_wip_entity_id
3034: from wip_move_transactions
3035: where transaction_id = p_move_id;
3036: end if;
3037:
3038: if (l_assm_item_id is NULL) then