APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 3566: FROM rcv_shipment_headers

3562: WHERE shipment_line_id = cp_shipment_line_id;
3563:
3564: CURSOR c_shp_hdr_dtls(cp_shipment_header_id IN NUMBER) IS
3565: SELECT shipment_header_id, receipt_num
3566: FROM rcv_shipment_headers
3567: WHERE shipment_header_id = cp_shipment_header_id;
3568:
3569: CURSOR c_loc_item_dtls(cp_organization_id IN NUMBER, cp_inventory_item_id IN NUMBER) IS
3570: SELECT item_class, modvat_flag, excise_flag, item_trading_flag

Line 3628: FROM rcv_shipment_headers

3624: SELECT nvl(count(distinct vendor_id), 0)
3625: from JAI_RCV_LINE_TAXES
3626: where shipment_line_id = cp_shipment_line_id
3627: AND vendor_id <> (SELECT vendor_id
3628: FROM rcv_shipment_headers
3629: WHERE shipment_header_id = cp_shipment_header_id
3630: )
3631: AND upper(tax_type) NOT IN (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery) --('TDS', 'MODVAT RECOVERY')
3632: AND tax_amount > 0 ;

Line 5134: from rcv_shipment_headers

5130: IS
5131:
5132: CURSOR c_shp_hdr(cp_transaction_id number) IS
5133: SELECT receipt_source_code
5134: from rcv_shipment_headers
5135: WHERE shipment_header_id = (select shipment_header_id
5136: from rcv_transactions
5137: where transaction_id = cp_transaction_id);
5138: