APPS.QA_SKIPLOT_RCV_GRP dependencies on RCV_TRANSACTIONS

Line 705: -- from rcv_transactions but rcv_transactions does

701: -- This API is being introduced since, AP Invoicing
702: -- creates an hold for skipped records for PO's created
703: -- with 4 Way Match with Receipt. This happens because
704: -- AP calls Receiving API to get the quantity details
705: -- from rcv_transactions but rcv_transactions does
706: -- not maintain details of Skipped lots.
707: -- returns x_skip_status = {fnd_api.g_true | fnd_api.g_false}
708: -- bhsankar Thu Jul 5 04:09:04 PDT 2007
709: --

Line 729: FROM qa_skiplot_rcv_results qa, rcv_transactions rt

725: l_msg_data VARCHAR2(2400);
726:
727: CURSOR C1 IS
728: SELECT count(qa.inspection_status)
729: FROM qa_skiplot_rcv_results qa, rcv_transactions rt
730: WHERE rt.interface_transaction_id = qa.interface_txn_id
731: AND rt.shipment_line_id = qa.shipment_line_id
732: AND qa.inspection_status = 'SKIPPED'
733: AND rt.transaction_id = p_transaction_id;