APPS.AP_ETAX_UTILITY_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 900: l_org_id po_line_locations_all.org_id%type;

896: l_return_status VARCHAR2(100);
897: l_msg_count NUMBER;
898: l_msg_data VARCHAR2(2000);
899:
900: l_org_id po_line_locations_all.org_id%type;
901: l_po_release_id po_line_locations_all.po_release_id%type;
902: l_doc_type VARCHAR2(20);
903:
904: l_api_name CONSTANT VARCHAR2(100) := 'Get_PO_Info';

Line 901: l_po_release_id po_line_locations_all.po_release_id%type;

897: l_msg_count NUMBER;
898: l_msg_data VARCHAR2(2000);
899:
900: l_org_id po_line_locations_all.org_id%type;
901: l_po_release_id po_line_locations_all.po_release_id%type;
902: l_doc_type VARCHAR2(20);
903:
904: l_api_name CONSTANT VARCHAR2(100) := 'Get_PO_Info';
905:

Line 908: FROM po_line_locations_all pll, po_headers_all ph, mtl_units_of_measure mum

904: l_api_name CONSTANT VARCHAR2(100) := 'Get_PO_Info';
905:
906: CURSOR PO_Info_from_line_loc (c_po_line_location_Id IN NUMBER) IS
907: SELECT pll.org_id, pll.quantity, pll.po_header_id, nvl(ph.rate ,1), pll.po_release_id, mum.uom_code
908: FROM po_line_locations_all pll, po_headers_all ph, mtl_units_of_measure mum
909: WHERE pll.line_location_id = c_po_line_location_Id
910: AND pll.po_header_id = ph.po_header_id
911: AND pll.unit_meas_lookup_code = mum.unit_of_measure (+);
912:

Line 917: FROM po_line_locations_all pll, po_distributions_all pd,

913: CURSOR PO_Info_from_dist (c_po_dist_Id IN NUMBER) IS
914: SELECT pll.org_id, pll.quantity, pll.line_location_id,
915: pll.po_header_id, nvl(ph.rate,1), pll.po_release_id, mum.uom_code,
916: pd.quantity_ordered, pll.price_override
917: FROM po_line_locations_all pll, po_distributions_all pd,
918: po_headers_all ph, mtl_units_of_measure mum
919: WHERE pd.po_distribution_id = c_po_dist_Id
920: AND pd.line_location_id = pll.line_location_id
921: AND pll.po_header_id = ph.po_header_id

Line 9663: FROM po_line_locations_all

9659: P_Inv_Line_Type NOT IN ('MISCELLANEOUS','FREIGHT') ) THEN --Bug14039130
9660:
9661: SELECT matching_basis, payment_type, shipment_type
9662: INTO l_matching_basis, l_payment_type, l_shipment_type
9663: FROM po_line_locations_all
9664: WHERE line_location_id = P_Line_Location_Id;
9665:
9666: IF l_matching_basis = 'AMOUNT' THEN
9667:

Line 9804: po_line_locations_all PLL,

9800: rsl.item_id rcv_item_id
9801: FROM ap_invoice_distributions_all D,
9802: po_distributions_all PD,
9803: po_lines_all PL,
9804: po_line_locations_all PLL,
9805: rcv_transactions RTXN,
9806: rcv_shipment_lines RSL
9807: WHERE D.invoice_distribution_id = c_inv_dist_id
9808: AND D.po_distribution_id = PD.po_distribution_id