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.AP_ETAX_UTILITY_PKG dependencies on PO_LINE_LOCATIONS

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 9612: l_matching_basis po_line_locations_ap_v.matching_basis%type;

9608: P_Line_Class OUT NOCOPY VARCHAR2,
9609: P_Error_Code OUT NOCOPY VARCHAR2,
9610: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
9611: IS
9612: l_matching_basis po_line_locations_ap_v.matching_basis%type;
9613: l_payment_type po_line_locations_ap_v.payment_type%type;
9614: l_shipment_type po_line_locations_ap_v.shipment_type%type;
9615:
9616: l_debug_info VARCHAR2(240);

Line 9613: l_payment_type po_line_locations_ap_v.payment_type%type;

9609: P_Error_Code OUT NOCOPY VARCHAR2,
9610: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
9611: IS
9612: l_matching_basis po_line_locations_ap_v.matching_basis%type;
9613: l_payment_type po_line_locations_ap_v.payment_type%type;
9614: l_shipment_type po_line_locations_ap_v.shipment_type%type;
9615:
9616: l_debug_info VARCHAR2(240);
9617: l_curr_calling_sequence VARCHAR2(4000);

Line 9614: l_shipment_type po_line_locations_ap_v.shipment_type%type;

9610: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN
9611: IS
9612: l_matching_basis po_line_locations_ap_v.matching_basis%type;
9613: l_payment_type po_line_locations_ap_v.payment_type%type;
9614: l_shipment_type po_line_locations_ap_v.shipment_type%type;
9615:
9616: l_debug_info VARCHAR2(240);
9617: l_curr_calling_sequence VARCHAR2(4000);
9618: l_api_name CONSTANT VARCHAR2(100) := 'Get_Line_Class';

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

Line 9816: l_match_option po_line_locations.match_option%TYPE;

9812: AND D.rcv_transaction_id = RTXN.transaction_id
9813: AND RTXN.shipment_line_id = RSL.shipment_line_id;
9814:
9815: l_match_basis po_line_types.matching_basis%TYPE;
9816: l_match_option po_line_locations.match_option%TYPE;
9817: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
9818: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;
9819: l_rct_item_id rcv_shipment_lines.item_id%TYPE;
9820: l_api_name CONSTANT VARCHAR2(100) := 'Get_Converted_Price';

Line 9817: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;

9813: AND RTXN.shipment_line_id = RSL.shipment_line_id;
9814:
9815: l_match_basis po_line_types.matching_basis%TYPE;
9816: l_match_option po_line_locations.match_option%TYPE;
9817: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
9818: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;
9819: l_rct_item_id rcv_shipment_lines.item_id%TYPE;
9820: l_api_name CONSTANT VARCHAR2(100) := 'Get_Converted_Price';
9821: l_debug_info VARCHAR2(240);

Line 9818: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;

9814:
9815: l_match_basis po_line_types.matching_basis%TYPE;
9816: l_match_option po_line_locations.match_option%TYPE;
9817: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
9818: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;
9819: l_rct_item_id rcv_shipment_lines.item_id%TYPE;
9820: l_api_name CONSTANT VARCHAR2(100) := 'Get_Converted_Price';
9821: l_debug_info VARCHAR2(240);
9822: