DBA Data[Home] [Help]

APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on RCV_SHIPMENT_LINES

Line 3561: FROM rcv_shipment_lines

3557: ) IS
3558:
3559: CURSOR c_shp_line_dtls(cp_shipment_line_id IN NUMBER) IS
3560: SELECT shipment_line_id, item_id
3561: FROM rcv_shipment_lines
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

Line 5141: FROM rcv_shipment_lines

5137: where transaction_id = cp_transaction_id);
5138:
5139: CURSOR c_shp_line(cp_shipment_line_id number) IS
5140: SELECT from_organization_id, to_organization_id
5141: FROM rcv_shipment_lines
5142: WHERE shipment_line_id = cp_shipment_line_id;
5143:
5144: CURSOR c_excise_tax_cnt(cp_shipment_line_id number) is
5145: SELECT count(1)