APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 3099: FROM rcv_shipment_headers

3095: WHERE shipment_line_id = cp_shipment_line_id;
3096:
3097: CURSOR c_shp_hdr_dtls(cp_shipment_header_id IN NUMBER) IS
3098: SELECT shipment_header_id, receipt_num
3099: FROM rcv_shipment_headers
3100: WHERE shipment_header_id = cp_shipment_header_id;
3101:
3102: CURSOR c_loc_item_dtls(cp_organization_id IN NUMBER, cp_inventory_item_id IN NUMBER) IS
3103: SELECT item_class, modvat_flag, excise_flag, item_trading_flag

Line 3161: FROM rcv_shipment_headers

3157: SELECT nvl(count(distinct vendor_id), 0)
3158: from JAI_RCV_LINE_TAXES
3159: where shipment_line_id = cp_shipment_line_id
3160: AND vendor_id <> (SELECT vendor_id
3161: FROM rcv_shipment_headers
3162: WHERE shipment_header_id = cp_shipment_header_id
3163: )
3164: AND upper(tax_type) NOT IN (jai_constants.tax_type_tds, jai_constants.tax_type_modvat_recovery) --('TDS', 'MODVAT RECOVERY')
3165: AND tax_amount > 0 ;

Line 4453: from rcv_shipment_headers

4449: IS
4450:
4451: CURSOR c_shp_hdr(cp_transaction_id number) IS
4452: SELECT receipt_source_code
4453: from rcv_shipment_headers
4454: WHERE shipment_header_id = (select shipment_header_id
4455: from rcv_transactions
4456: where transaction_id = cp_transaction_id);
4457: