DBA Data[Home] [Help]

APPS.POS_ASN_SEARCH_PKG dependencies on PO_LINE_LOCATIONS

Line 686: from po_line_locations

682: select SHIP_TO_ORGANIZATION_ID,
683: ship_to_location_id
684: into l_ship_to_org_id,
685: l_ship_to_loc_id
686: from po_line_locations
687: where line_location_id = l_po_shipment_id;
688:
689: if l_first_org_id = -1 then
690: l_first_org_id := l_ship_to_org_id;

Line 738: from po_line_locations poll,

734: into l_ship_to_org_id,
735: l_ship_to_loc_id,
736: l_vendor_id,
737: l_vendor_site_id
738: from po_line_locations poll,
739: po_headers poh
740: where poh.po_header_id = poll.po_header_id
741: and poll.line_location_id = l_po_shipment_id;
742:

Line 789: from po_line_locations poll,

785: into l_po_header_id,
786: l_po_line_id,
787: l_ship_to_org_id,
788: l_unit_meas_lookup_code
789: from po_line_locations poll,
790: po_lines pol
791: where poll.line_location_id = l_po_shipment_id
792: and poll.po_line_id = pol.po_line_id;
793: