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_SERVICES_PKG dependencies on PO_LINE_LOCATIONS

Line 101: | Procedure to return ship to organization id from po_line_locations

97: /*=============================================================================
98: | FUNCTION - get_po_ship_to_org_id()
99: |
100: | DESCRIPTION
101: | Procedure to return ship to organization id from po_line_locations
102: | table.
103: |
104: | PARAMETERS
105: | p_po_line_location_id

Line 189: FROM po_line_locations_all pll

185: ELSE /*Bug 13079028*/
186:
187: SELECT SHIP_TO_ORGANIZATION_ID
188: INTO l_po_ship_to_org_id
189: FROM po_line_locations_all pll
190: WHERE pll.line_location_id = p_po_line_location_Id;
191:
192:
193: l_debug_info := 'Step 2.2: Check SHIP_TO_ORG_ID '||l_po_ship_to_org_id;

Line 6974: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269

6970:
6971: l_api_name VARCHAR2(30) := 'Populate_Lines_GT';
6972: l_tax_already_calculated_line VARCHAR2(1);
6973:
6974: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
6975:
6976: l_err varchar2(2000); --10140354
6977: BEGIN
6978:

Line 8239: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269

8235:
8236: l_prorating_total NUMBER;
8237: l_total_prorated NUMBER;
8238:
8239: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
8240:
8241: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Lines_Import_GT';
8242:
8243: l_copy_line_dff_flag VARCHAR2(1) := 'N'; -- Bug10082937

Line 10048: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269

10044: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
10045: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
10046: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
10047: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
10048: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
10049:
10050: k INT := 1;
10051: l_pseudo INT := 1;
10052:

Line 11028: l_po_unit_price po_line_locations_all.price_override%TYPE;

11024: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
11028: l_po_unit_price po_line_locations_all.price_override%TYPE;
11029: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
11030: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11031: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11032: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 11029: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;

11025: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
11026: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
11027: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
11028: l_po_unit_price po_line_locations_all.price_override%TYPE;
11029: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
11030: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
11031: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
11032: l_uom_code mtl_units_of_measure.uom_code%TYPE;
11033:

Line 11375: FROM po_lines_all POL , po_line_locations_all PLL

11371: OR (l_inv_dist_list(i).retained_invoice_dist_id IS NOT NULL and l_inv_dist_list(i).po_distribution_id IS NOT NULL)) THEN
11372:
11373: BEGIN
11374: SELECT POL.retainage_rate INTO l_retainage_rate
11375: FROM po_lines_all POL , po_line_locations_all PLL
11376: WHERE PLL.po_header_id = POL.po_header_id
11377: AND PLL.po_line_id = POL.po_line_id
11378: AND PLL.line_location_id = l_po_line_location_id
11379: AND PLL.po_header_id = l_ref_doc_trx_id;

Line 16496: po_line_locations_all PLL,

16492: rsl.item_id rcv_item_id
16493: FROM ap_invoice_distributions_all D,
16494: po_distributions_all PD,
16495: po_lines_all PL,
16496: po_line_locations_all PLL,
16497: rcv_transactions RTXN,
16498: rcv_shipment_lines RSL
16499: WHERE D.invoice_distribution_id = c_inv_dist_id
16500: AND D.po_distribution_id = PD.po_distribution_id

Line 16508: l_match_option po_line_locations.match_option%TYPE;

16504: AND D.rcv_transaction_id = RTXN.transaction_id
16505: AND RTXN.shipment_line_id = RSL.shipment_line_id;
16506:
16507: l_match_basis po_line_types.matching_basis%TYPE;
16508: l_match_option po_line_locations.match_option%TYPE;
16509: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
16510: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;
16511: l_rct_item_id rcv_shipment_lines.item_id%TYPE;
16512:

Line 16509: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;

16505: AND RTXN.shipment_line_id = RSL.shipment_line_id;
16506:
16507: l_match_basis po_line_types.matching_basis%TYPE;
16508: l_match_option po_line_locations.match_option%TYPE;
16509: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
16510: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;
16511: l_rct_item_id rcv_shipment_lines.item_id%TYPE;
16512:
16513: l_uom_conv_rate NUMBER;

Line 16510: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;

16506:
16507: l_match_basis po_line_types.matching_basis%TYPE;
16508: l_match_option po_line_locations.match_option%TYPE;
16509: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
16510: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;
16511: l_rct_item_id rcv_shipment_lines.item_id%TYPE;
16512:
16513: l_uom_conv_rate NUMBER;
16514: l_qty_invoiced NUMBER;

Line 16812: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269

16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
16809: l_assessable_value zx_lines_det_factors.assessable_value%type;
16810: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
16811: l_allow_tax_code_override VARCHAR2(10);
16812: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
16813:
16814: l_debug_info Varchar2(240);
16815: l_curr_calling_sequence Varchar2(4000);
16816: l_return_status BOOLEAN := TRUE;