DBA Data[Home] [Help]

APPS.PO_GML_DB_COMMON dependencies on RCV_LOT_TRANSACTIONS

Line 567: From rcv_lot_transactions

563:
564:
565: CURSOR Cur_rcv_lot_txn(l_parent_transaction_id IN NUMBER, v_lot_num IN VARCHAR2, v_sublot_num IN VARCHAR2) IS
566: Select PRIMARY_QUANTITY
567: From rcv_lot_transactions
568: where TRANSACTION_ID = l_parent_transaction_id
569: and LOT_NUM = v_lot_num
570: and SUBLOT_NUM = v_sublot_num;
571:

Line 687: Check if rcv_Lots_interface records for return match with rcv_lot_transactions for receipt

683: IF (l_trx_type = 'RETURN TO VENDOR' or l_trx_type = 'RETURN TO RECEIVING')
684:
685: Check Profile OPtion GML Validate return
686: Check Receipt_qty = Return qty in same UM's in rcv_transactions
687: Check if rcv_Lots_interface records for return match with rcv_lot_transactions for receipt
688: then find ic_tran_pnd record for rcv_lots_interface for receipt and copy the quantitiy.
689:
690: If anything does not match do Nothing */
691: