APPS.JAI_PO_HOOK_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 105: po_line_locations_all poll

101: -- rtxns.CURRENCY_CONVERSION_DATE, /*rchandan for 5961325*/
102: poll.org_id /*rchandan for 5961325*/
103: FROM JAI_CMN_LINES lines,
104: RCV_TRANSACTIONS_INTERFACE rtxns,
105: po_line_locations_all poll
106: WHERE lines.interface_transaction_id =
107: rtxns.interface_transaction_id
108: AND lines.HEADER_INTERFACE_ID = rtxns.HEADER_INTERFACE_ID
109: AND lines.po_line_location_id = poll.line_location_id

Line 872: FROM po_line_locations_all

868: (SELECT currency_code
869: FROM po_headers_all
870: WHERE po_header_id = rtxn.po_header_id) CUR_CODE,
871: (SELECT quantity
872: FROM po_line_locations_all
873: WHERE LINE_LOCATION_ID = rtxn.PO_LINE_LOCATION_ID) TOT_QUANTITY
874: FROM rcv_transactions_interface rtxn
875: WHERE rtxn.HEADER_INTERFACE_ID = cp_hdr_intf_id;
876:

Line 889: FROM po_line_locations_all

885: WHERE PO_HEADER_ID = cp_po_header_id;
886:
887: CURSOR c_po_line_loc_details(cp_line_location_id IN NUMBER) IS
888: SELECT *
889: FROM po_line_locations_all
890: WHERE line_location_id = cp_line_location_id;
891:
892: r_line_locations c_po_line_loc_details%ROWTYPE;
893:

Line 1315: po_line_locations_all b

1311: || for a release the po_line_locations_table will have all the details
1312: */
1313: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1314: FROM JAI_PO_TAXES a,
1315: po_line_locations_all b
1316: WHERE b.po_header_id = p_header_id
1317: AND b.po_release_id = p_line_id
1318: AND a.po_header_id = b.po_header_id
1319: AND a.po_line_id = b.po_line_id

Line 1524: FROM po_line_locations_all

1520: p_shipment_line_num IN NUMBER
1521: ) RETURN NUMBER IS
1522: CURSOR c_line_location IS
1523: SELECT line_location_id
1524: FROM po_line_locations_all
1525: WHERE po_line_id = p_line_id
1526: AND shipment_num = p_shipment_line_num;
1527:
1528: ln_line_location_id NUMBER;

Line 1654: po_line_locations_all b

1650: -- commented out by pramasub
1651: CURSOR c_po_ppo IS
1652: SELECT a.line_location_id, currency, SUM(tax_amount) tax_amount
1653: FROM JAI_PO_TAXES a,
1654: po_line_locations_all b
1655: WHERE a.po_header_id = p_header_id
1656: AND a.po_header_id = b.po_header_id
1657: AND a.po_line_id = b.po_line_id
1658: AND a.line_location_id = b.line_location_id

Line 1666: po_line_locations_all b

1662:
1663: CURSOR c_po_bpa IS
1664: SELECT a.line_location_id, currency, SUM(tax_amount) tax_amount
1665: FROM JAI_PO_TAXES a,
1666: po_line_locations_all b
1667: WHERE a.po_header_id = p_header_id
1668: AND a.po_header_id = b.po_header_id
1669: AND a.po_line_id = b.po_line_id
1670: AND a.line_location_id = b.line_location_id

Line 1725: from po_line_locations_all

1721:
1722: FOR rec in (select shipment_header_id,shipment_line_id
1723: from rcv_shipment_lines
1724: WHERE po_line_location_id IN (select line_Location_id
1725: from po_line_locations_all
1726: where po_header_id=p_header_id)
1727: AND (po_release_id = p_release_id or p_release_id is null)
1728: )
1729: LOOP

Line 1740: from po_line_locations_all

1736:
1737: FOR rec in (select distinct invoice_id
1738: from ap_invoice_lines_all
1739: where po_line_location_id IN (select line_Location_id
1740: from po_line_locations_all
1741: where po_header_id=p_header_id)
1742: AND (po_release_id = p_release_id or p_release_id is null)
1743: )
1744: LOOP

Line 1936: po_line_locations_all b

1932: || for a release the po_line_locations_table will have all the details
1933: */
1934: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1935: FROM JAI_PO_TAXES a,
1936: po_line_locations_all b
1937: WHERE b.po_header_id = p_header_id
1938: AND b.po_release_id = p_release_id
1939: AND (p_line_id IS NULL OR b.po_line_id = p_line_id)
1940: AND a.po_header_id = b.po_header_id

Line 1978: po_line_locations_all b,

1974: || for a release the po_line_locations_table will have all the details
1975: */
1976: FOR r_release_rec IN (SELECT currency, SUM(tax_amount) tax_amount
1977: FROM JAI_PO_TAXES a,
1978: po_line_locations_all b,
1979: po_releases_all c -- added by pramasub #6441185
1980: WHERE b.po_header_id = p_header_id
1981: AND b.po_release_id is not null
1982: AND a.po_header_id = b.po_header_id

Line 2238: , po_line_locations_all plla

2234: jpt.currency
2235: , SUM(jpt.tax_amount) tax_amount
2236: FROM
2237: jai_po_taxes jpt
2238: , po_line_locations_all plla
2239: , jai_cmn_taxes_all jcta
2240: WHERE plla.po_header_id = pn_header_id
2241: AND plla.po_release_id = pn_line_id
2242: AND jpt.po_header_id = plla.po_header_id

Line 2627: , po_line_locations_all plla

2623: , jpt.currency
2624: , SUM(jpt.tax_amount) tax_amount
2625: FROM
2626: JAI_PO_TAXES jpt
2627: , po_line_locations_all plla
2628: , jai_cmn_taxes_all jcta
2629: WHERE jpt.po_header_id = pn_header_id
2630: AND jpt.po_header_id = plla.po_header_id
2631: AND jpt.po_line_id = plla.po_line_id

Line 2647: , po_line_locations_all plla

2643: , jpt.currency
2644: , SUM(jpt.tax_amount) tax_amount
2645: FROM
2646: jai_po_taxes jpt
2647: , po_line_locations_all plla
2648: , jai_cmn_taxes_all jcta
2649: WHERE jpt.po_header_id = pn_header_id
2650: AND jpt.po_header_id = plla.po_header_id
2651: AND jpt.po_line_id = plla.po_line_id

Line 2689: , po_line_locations_all plla

2685: jpt.currency
2686: , SUM(jpt.tax_amount) tax_amount
2687: FROM
2688: jai_po_taxes jpt
2689: , po_line_locations_all plla
2690: , jai_cmn_taxes_all jcta
2691: WHERE plla.po_header_id = pn_header_id
2692: AND plla.po_release_id = pn_release_id
2693: AND (pn_line_id IS NULL OR plla.po_line_id = pn_line_id)

Line 2722: , po_line_locations_all plla

2718: jpt.currency
2719: , SUM(jpt.tax_amount) tax_amount
2720: FROM
2721: JAI_PO_TAXES jpt
2722: , po_line_locations_all plla
2723: , po_releases_all pra
2724: , jai_cmn_taxes_all jcta
2725: WHERE plla.po_header_id = pn_header_id
2726: AND plla.po_release_id IS NOT NULL