APPS.JAI_PO_HOOK_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 145: po_line_locations_all poll

141: -- rtxns.CURRENCY_CONVERSION_DATE, /*rchandan for 5961325*/
142: poll.org_id /*rchandan for 5961325*/
143: FROM JAI_CMN_LINES lines,
144: RCV_TRANSACTIONS_INTERFACE rtxns,
145: po_line_locations_all poll
146: WHERE lines.interface_transaction_id =
147: rtxns.interface_transaction_id
148: AND lines.HEADER_INTERFACE_ID = rtxns.HEADER_INTERFACE_ID
149: AND lines.po_line_location_id = poll.line_location_id

Line 964: FROM po_line_locations_all

960: (SELECT currency_code
961: FROM po_headers_all
962: WHERE po_header_id = rtxn.po_header_id) CUR_CODE,
963: (SELECT quantity
964: FROM po_line_locations_all
965: WHERE LINE_LOCATION_ID = rtxn.PO_LINE_LOCATION_ID) TOT_QUANTITY
966: FROM rcv_transactions_interface rtxn
967: WHERE rtxn.HEADER_INTERFACE_ID = cp_hdr_intf_id;
968:

Line 981: FROM po_line_locations_all

977: WHERE PO_HEADER_ID = cp_po_header_id;
978:
979: CURSOR c_po_line_loc_details(cp_line_location_id IN NUMBER) IS
980: SELECT *
981: FROM po_line_locations_all
982: WHERE line_location_id = cp_line_location_id;
983:
984: r_line_locations c_po_line_loc_details%ROWTYPE;
985:

Line 1444: po_line_locations_all b

1440: || for a release the po_line_locations_table will have all the details
1441: */
1442: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1443: FROM JAI_PO_TAXES a,
1444: po_line_locations_all b
1445: WHERE b.po_header_id = p_header_id
1446: AND b.po_release_id = p_line_id
1447: AND a.po_header_id = b.po_header_id
1448: AND a.po_line_id = b.po_line_id

Line 1653: FROM po_line_locations_all

1649: p_shipment_line_num IN NUMBER
1650: ) RETURN NUMBER IS
1651: CURSOR c_line_location IS
1652: SELECT line_location_id
1653: FROM po_line_locations_all
1654: WHERE po_line_id = p_line_id
1655: AND shipment_num = p_shipment_line_num;
1656:
1657: ln_line_location_id NUMBER;

Line 1791: po_line_locations_all b

1787: -- commented out by pramasub
1788: CURSOR c_po_ppo IS
1789: SELECT a.line_location_id, currency, SUM(tax_amount) tax_amount
1790: FROM JAI_PO_TAXES a,
1791: po_line_locations_all b
1792: WHERE a.po_header_id = p_header_id
1793: AND a.po_header_id = b.po_header_id
1794: AND a.po_line_id = b.po_line_id
1795: AND a.line_location_id = b.line_location_id

Line 1803: po_line_locations_all b

1799:
1800: CURSOR c_po_bpa IS
1801: SELECT a.line_location_id, currency, SUM(tax_amount) tax_amount
1802: FROM JAI_PO_TAXES a,
1803: po_line_locations_all b
1804: WHERE a.po_header_id = p_header_id
1805: AND a.po_header_id = b.po_header_id
1806: AND a.po_line_id = b.po_line_id
1807: AND a.line_location_id = b.line_location_id

Line 1886: from po_line_locations_all

1882:
1883: FOR rec in (select shipment_header_id,shipment_line_id
1884: from rcv_shipment_lines
1885: WHERE po_line_location_id IN (select line_Location_id
1886: from po_line_locations_all
1887: where po_header_id=p_header_id)
1888: AND (po_release_id = p_release_id or p_release_id is null)
1889: )
1890: LOOP

Line 1915: from po_line_locations_all

1911:
1912: FOR rec in (select distinct invoice_id
1913: from ap_invoice_lines_all
1914: where po_line_location_id IN (select line_Location_id
1915: from po_line_locations_all
1916: where po_header_id=p_header_id)
1917: AND (po_release_id = p_release_id or p_release_id is null)
1918: )
1919: LOOP

Line 2124: po_line_locations_all b

2120: || for a release the po_line_locations_table will have all the details
2121: */
2122: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2123: FROM JAI_PO_TAXES a,
2124: po_line_locations_all b
2125: WHERE b.po_header_id = p_header_id
2126: AND b.po_release_id = p_release_id
2127: AND (p_line_id IS NULL OR b.po_line_id = p_line_id)
2128: AND a.po_header_id = b.po_header_id

Line 2166: po_line_locations_all b,

2162: || for a release the po_line_locations_table will have all the details
2163: */
2164: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
2165: FROM JAI_PO_TAXES a,
2166: po_line_locations_all b,
2167: po_releases_all c -- added by pramasub #6441185
2168: WHERE b.po_header_id = p_header_id
2169: AND b.po_release_id is not null
2170: AND a.po_header_id = b.po_header_id

Line 2440: , po_line_locations_all plla

2436: jpt.currency
2437: , SUM(jpt.tax_amount) tax_amount
2438: FROM
2439: jai_po_taxes jpt
2440: , po_line_locations_all plla
2441: , jai_cmn_taxes_all jcta
2442: WHERE plla.po_header_id = pn_header_id
2443: AND plla.po_release_id = pn_line_id
2444: AND jpt.po_header_id = plla.po_header_id

Line 2829: , po_line_locations_all plla

2825: , jpt.currency
2826: , SUM(jpt.tax_amount) tax_amount
2827: FROM
2828: JAI_PO_TAXES jpt
2829: , po_line_locations_all plla
2830: , jai_cmn_taxes_all jcta
2831: WHERE jpt.po_header_id = pn_header_id
2832: AND jpt.po_header_id = plla.po_header_id
2833: AND jpt.po_line_id = plla.po_line_id

Line 2849: , po_line_locations_all plla

2845: , jpt.currency
2846: , SUM(jpt.tax_amount) tax_amount
2847: FROM
2848: jai_po_taxes jpt
2849: , po_line_locations_all plla
2850: , jai_cmn_taxes_all jcta
2851: WHERE jpt.po_header_id = pn_header_id
2852: AND jpt.po_header_id = plla.po_header_id
2853: AND jpt.po_line_id = plla.po_line_id

Line 2891: , po_line_locations_all plla

2887: jpt.currency
2888: , SUM(jpt.tax_amount) tax_amount
2889: FROM
2890: jai_po_taxes jpt
2891: , po_line_locations_all plla
2892: , jai_cmn_taxes_all jcta
2893: WHERE plla.po_header_id = pn_header_id
2894: AND plla.po_release_id = pn_release_id
2895: AND (pn_line_id IS NULL OR plla.po_line_id = pn_line_id)

Line 2924: , po_line_locations_all plla

2920: jpt.currency
2921: , SUM(jpt.tax_amount) tax_amount
2922: FROM
2923: JAI_PO_TAXES jpt
2924: , po_line_locations_all plla
2925: , po_releases_all pra
2926: , jai_cmn_taxes_all jcta
2927: WHERE plla.po_header_id = pn_header_id
2928: AND plla.po_release_id IS NOT NULL