APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PO_LINES_ALL

Line 1440: , po_lines_all pol

1436: -- ,fsp.inventory_organization_id organization_id /* Commented by vkantamn for Bug#6083978 */
1437: ,hl.inventory_organization_id organization_id /* Added by vkantamn for Bug#6083978 */
1438: ,poll.ship_to_location_id location_id
1439: from po_headers_all poh
1440: , po_lines_all pol
1441: , po_line_locations_all poll /*6841116*/
1442: , mtl_system_items msi
1443: , po_vendors pov
1444: , hr_locations hl /* Added by vkantamn for Bug#6083978 */

Line 1481: , po_lines_all pla

1477: ,rsl.ship_to_location_id location_id
1478: from rcv_transactions rta
1479: , rcv_shipment_headers rsh
1480: , rcv_shipment_lines rsl
1481: , po_lines_all pla
1482: , mtl_system_items msi
1483: , po_vendors pov
1484: , hr_locations_all hl
1485: where

Line 1611: cursor c_get_po_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )

1607: and padi.ship_to_customer_id=c.customer_id;
1608: -- End 5876390, 6012570
1609:
1610:
1611: cursor c_get_po_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )
1612: is
1613: select service_type_code, sum(jpollt.tax_amount) service_tax_amount
1614: from JAI_PO_LINE_LOCATIONS jpoll
1615: ,jai_po_taxes jpollt

Line 1624: cursor c_get_rcv_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )

1620: --and jpollt.tax_type = 'Service'
1621: group by service_type_code;
1622:
1623: /*Bug 12902363 - Start*/
1624: cursor c_get_rcv_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )
1625: is
1626: select service_type_code, sum(jrlt.tax_amount) service_tax_amount
1627: from JAI_PO_LINE_LOCATIONS jpoll
1628: ,jai_rcv_line_taxes jrlt