APPS.POR_RCV_ORD_SV dependencies on RCV_SHIPMENT_LINES

Line 45: from rcv_shipment_lines rsl, rcv_shipment_headers rsh

41:
42:
43: cursor rcv_header(p_lineLocationId number) is
44: select rsl.shipment_line_id, rsl.quantity_shipped, nvl(rsl.quantity_received,0), rsl.unit_of_measure
45: from rcv_shipment_lines rsl, rcv_shipment_headers rsh
46: where rsl.po_line_location_id = p_lineLocationId
47: and nvl(rsl.quantity_shipped, 0) > nvl(rsl.quantity_received, 0)
48: and rsl.shipment_header_id = rsh.shipment_header_id
49: and rsh.asn_type in ('ASN','ASBN');

Line 400: from rcv_shipment_lines

396: is
397:
398: cursor rcv_header(p_reqLineId number) is
399: select shipment_line_id, quantity_shipped, nvl(quantity_received,0), unit_of_measure
400: from rcv_shipment_lines
401: where requisition_line_id = p_reqLineId
402: and nvl(quantity_shipped, 0) > nvl(quantity_received, 0);
403:
404: l_reqLineId number := 0;

Line 778: RCV_SHIPMENT_LINES RSL,

774: X_Comments,
775: X_WayBillNum,
776: NULL
777: FROM RCV_SHIPMENT_HEADERS RSH,
778: RCV_SHIPMENT_LINES RSL,
779: MTL_SYSTEM_ITEMS MSI
780: WHERE RSH.RECEIPT_SOURCE_CODE <> 'VENDOR' AND
781: RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID AND
782: MSI.ORGANIZATION_ID (+) = RSL.TO_ORGANIZATION_ID AND

Line 891: from rcv_shipment_lines

887:
888: if (x_source_type_code = 'ASN') then
889: select shipment_header_id
890: into l_rcv_shipment_header_id
891: from rcv_shipment_lines
892: where shipment_line_id = X_rcv_shipment_line_id;
893: end if;
894:
895: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE l_rcv_shipment_header_id:' || l_rcv_shipment_header_id);