APPS.JAI_PO_WF_UTIL_PUB dependencies on PO_LINE_LOCATIONS

Line 524: PO_LINE_LOCATIONS_ALL PLLA

520: , NVL(JPT.tax_amount,0)
521: , JPT.currency
522: , NVL(JPT.modvat_flag,'N') --add by Xiao Lv for IL po notification on Mar-25-2009
523: FROM
524: PO_LINE_LOCATIONS_ALL PLLA
525: , JAI_PO_TAXES JPT
526: WHERE PLLA.LINE_LOCATION_ID = JPT.LINE_LOCATION_ID
527: AND PLLA.PO_RELEASE_ID = pn_document_id;
528:

Line 1350: , PO_LINE_LOCATIONS_ALL PLLA

1346: , JPT.currency
1347: , JPT.modvat_flag
1348: FROM
1349: PO_RELEASES_ALL POA
1350: , PO_LINE_LOCATIONS_ALL PLLA
1351: , JAI_PO_TAXES JPT
1352: WHERE PLLA.LINE_LOCATION_ID = JPT.LINE_LOCATION_ID
1353: AND POA.PO_HEADER_ID = PLLA.PO_HEADER_ID
1354: AND POA.PO_RELEASE_ID = PLLA.PO_RELEASE_ID

Line 1589: , po_line_locations poll

1585: , NVL(poll.closed_code, 'OPEN')
1586: , pol.closed_code)
1587: FROM po_headers poh
1588: , po_lines pol
1589: , po_line_locations poll
1590: , po_distributions pod
1591: WHERE poh.po_header_id = p_document_id
1592: AND pol.po_header_id = poh.po_header_id
1593: AND poll.po_line_id = pol.po_line_id

Line 1669: , po_line_locations poll

1665: , pol.category_id
1666: , DECODE(nvl(pol.cancel_flag, 'N'), 'N', NVL(poll.cancel_flag, 'N'), pol.cancel_flag)
1667: , DECODE(nvl(pol.closed_code, 'OPEN'), 'OPEN', NVL(poll.closed_code, 'OPEN'), pol.closed_code)
1668: FROM po_distributions pod
1669: , po_line_locations poll
1670: , po_lines pol
1671: , po_releases_all poa
1672: WHERE poa.po_release_id = p_document_id
1673: AND poll.po_release_id = p_document_id