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 513: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)

509: AND vendor_site_id = ven_site_id
510: AND NVL(org_id, -1) = NVL(v_org_id, -1);
511:
512: /*below cursor added for bug 6595773*/
513: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
514: is
515: select ship_to_organization_id
516: ,ship_to_location_id
517: from po_line_locations_all plla

Line 517: from po_line_locations_all plla

513: cursor c_get_ship_to_org_loc (cpn_line_location_id po_line_locations_all.line_location_id%type)
514: is
515: select ship_to_organization_id
516: ,ship_to_location_id
517: from po_line_locations_all plla
518: where plla.line_location_id = cpn_line_location_id;
519:
520:
521: -- Cursor modified to use pn_invoice_line_number instead of distribution_line_number, bug#4445989

Line 941: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;

937: v_apportn_factor_for_item_line NUMBER; -- Bug#3752887
938:
939: /*following variables added for bug 6595773*/
940: ln_vat_regime_id jai_rgm_definitions.regime_id%type;
941: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
942: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
943:
944:
945: /* 5763527 , Project costing Fwd porting*/

Line 942: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;

938:
939: /*following variables added for bug 6595773*/
940: ln_vat_regime_id jai_rgm_definitions.regime_id%type;
941: ln_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
942: ln_ship_to_location_id po_line_locations_all.ship_to_location_id%type;
943:
944:
945: /* 5763527 , Project costing Fwd porting*/
946: ln_project_id ap_invoice_distributions_all.project_id%TYPE;

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

1589: change in price too. In such cases, UOM is also taken into account for changes
1590: in quantity and price.
1591:
1592: UOM at PO was being checked always from po_line_locations. But there are cases
1593: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.
1594: Changed the code to check from po_lines_all whenever UOM does not exist in
1595: Po_line_locations_all.
1596:
1597: 37 11/06/2004 Aparajita for bug#3671967. Version#115.2

Line 1595: Po_line_locations_all.

1591:
1592: UOM at PO was being checked always from po_line_locations. But there are cases
1593: like BPA, where the UOM is in po_lines_all in stead of po_line_locations_all.
1594: Changed the code to check from po_lines_all whenever UOM does not exist in
1595: Po_line_locations_all.
1596:
1597: 37 11/06/2004 Aparajita for bug#3671967. Version#115.2
1598:
1599: When the tax line being brought over from PO by way of PO matching,

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

8507:
8508: ELSIF rcv_tran_id IS NULL and v_source IN ('ERS', 'ASBN', 'RTS') THEN
8509:
8510: --IF rcv_tran_id IS NOT NULL THEN
8511: -- to be fired when po_line_locations_all.match_option = 'P'
8512:
8513: Fnd_File.put_line(Fnd_File.LOG, 'Fired when rcv_tran_id IS NULL, match_option is P');
8514:
8515: -- fetch shipment_num from rcv_headers_interface based on invoice_num