eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_CREATE_ASN dependencies on PO_LINE_LOCATIONS_ALL

Line 143: from po_line_locations_all

139: x_progress := '015' ;
140:
141: select ship_to_location_id
142: into x_ship_to_location_id
143: from po_line_locations_all
144: where line_location_id = P_PO_LINE_LOCATION_ID_T;
145:
146: /* Insert into RHI only if a record for the same ship_to_org
147: and ship_to_location is not already inserted for the group id */

Line 661: l_line_location_id po_line_locations_all.LINE_LOCATION_ID%TYPE;

657: x_item_id NUMBER;
658: x_primary_uom VARCHAR2(26);
659: x_interface_qty_in_po_uom NUMBER := 0;
660:
661: l_line_location_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
662: l_distribution_type po_distributions_all.distribution_type%TYPE;
663: l_matching_basis po_line_locations_all.matching_basis%TYPE;
664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;

Line 663: l_matching_basis po_line_locations_all.matching_basis%TYPE;

659: x_interface_qty_in_po_uom NUMBER := 0;
660:
661: l_line_location_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
662: l_distribution_type po_distributions_all.distribution_type%TYPE;
663: l_matching_basis po_line_locations_all.matching_basis%TYPE;
664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;
666: l_budget_account_id po_distributions_all.budget_account_id%TYPE;
667: l_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;

Line 668: l_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;

664: l_accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE;
665: l_code_combination_id po_distributions_all.code_combination_id%TYPE;
666: l_budget_account_id po_distributions_all.budget_account_id%TYPE;
667: l_partial_funded_flag po_distributions_all.partial_funded_flag%TYPE;
668: l_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
669: l_funded_value NUMBER;
670: l_quantity_funded NUMBER;
671: l_amount_funded NUMBER;
672: l_quantity_received NUMBER;

Line 708: FROM po_line_locations_all pll,

704: x_qty_rcv_tolerance,
705: x_qty_rcv_exception_code,
706: x_item_id,
707: x_po_uom
708: FROM po_line_locations_all pll,
709: po_lines_all pl
710: WHERE pll.line_location_id = p_line_location_id
711: AND pll.po_line_id = pl.po_line_id;
712:

Line 762: PO_LINE_LOCATIONS_ALL POLL,

758:
759: SELECT Nvl(PDSH.CLM_FLAG,'N') CLM_FLAG
760: INTO l_clm_flag
761: FROM PO_HEADERS_ALL POH,
762: PO_LINE_LOCATIONS_ALL POLL,
763: PO_DOC_STYLE_HEADERS PDSH
764: WHERE POLL.LINE_LOCATION_ID = l_line_location_id AND
765: POLL.PO_HEADER_ID = POH.PO_HEADER_ID AND
766: NVL(POH.STYLE_ID, 1) = PDSH.STYLE_ID (+) AND

Line 913: FROM po_line_locations_all pll,

909: SELECT pl.item_id,
910: pl.unit_meas_lookup_code
911: INTO x_item_id,
912: x_po_uom
913: FROM po_line_locations_all pll,
914: po_lines_all pl
915: WHERE pll.line_location_id = p_line_location_id
916: AND pll.po_line_id = pl.po_line_id;
917: