APPS.JAI_AP_MATCH_TAX_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 54: FROM po_line_locations_all

50: /*5694855..start* kunkumar for forward porting to R12*/
51: CURSOR cur_fetch_io IS
52: SELECT ship_to_organization_id,
53: ship_to_location_id
54: FROM po_line_locations_all
55: WHERE line_location_id IN ( SELECT line_location_id
56:
57: FROM po_distributions_all
58: WHERE po_distribution_id = po_dist_id) ;

Line 673: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)

669: AND vendor_site_id = ven_site_id
670: AND NVL(org_id, -1) = NVL(v_org_id, -1);
671:
672: /*below cursor added for bug 6595773*/
673: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
674: is
675: select ship_to_organization_id
676: ,ship_to_location_id
677: from po_line_locations_all plla

Line 677: from po_line_locations_all plla

673: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
674: is
675: select ship_to_organization_id
676: ,ship_to_location_id
677: from po_line_locations_all plla
678: where plla.line_location_id = cpn_line_location_id;
679:
680:
681: -- Cursor modified to use pn_invoice_line_number instead of distribution_line_number, bug#4445989

Line 1238: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;

1234: v_apportn_factor_for_adhoc NUMBER; --Added by nprashar for bug # 13363329
1235:
1236: /*following variables added for bug 6595773*/
1237: ln_vat_regime_id jai_rgm_definitions.regime_id%type;
1238: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
1239: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
1240:
1241:
1242: /* 5763527 , Project costing Fwd porting*/

Line 1239: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;

1235:
1236: /*following variables added for bug 6595773*/
1237: ln_vat_regime_id jai_rgm_definitions.regime_id%type;
1238: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
1239: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
1240:
1241:
1242: /* 5763527 , Project costing Fwd porting*/
1243: ln_project_id ap_invoice_distributions_all.project_id%TYPE;

Line 1920: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.

1916: change in price too. In such cases, UOM is also taken into account for changes
1917: in quantity and price.
1918:
1919: UOM at PO was being checked always from po_line_locations. But there are cases
1920: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.
1921: Changed the code to check from po_lines_all whenever UOM does not exist in
1922: Po_line_locations_all.
1923:
1924: 37 11/06/2004 Aparajita for bug#3671967. Version#115.2

Line 1922: Po_line_locations_all.

1918:
1919: UOM at PO was being checked always from po_line_locations. But there are cases
1920: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.
1921: Changed the code to check from po_lines_all whenever UOM does not exist in
1922: Po_line_locations_all.
1923:
1924: 37 11/06/2004 Aparajita for bug#3671967. Version#115.2
1925:
1926: When the tax line being brought over from PO by way of PO matching,

Line 10095: -- to be fired when po_line_locations_all.match_option = 'P'

10091:
10092: ELSIF rcv_tran_id IS NULL and v_source IN ('ERS', 'ASBN', 'RTS') THEN
10093:
10094: --IF rcv_tran_id IS NOT NULL THEN
10095: -- to be fired when po_line_locations_all.match_option = 'P'
10096:
10097: Fnd_File.put_line(Fnd_File.LOG, 'Fired when rcv_tran_id IS NULL, match_option is P');
10098:
10099: -- fetch shipment_num from rcv_headers_interface based on invoice_num