eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_POAPPROVAL_INIT1 dependencies on PO_LINE_LOCATIONS

Line 776: po_line_locations_all POLL

772: ) * X_min_acct_unit
773: ),0)
774: INTO l_tax_amount
775: FROM po_distributions_all POD,
776: po_line_locations_all POLL
777: WHERE POD.po_header_id = POHdr_rec.po_header_id
778: AND POD.line_location_id=POLL.line_location_id
779: AND POD.po_header_id=POLL.po_header_id
780: AND Nvl(POD.distribution_type,'STANDARD') NOT IN ('PREPAYMENT') --11876122

Line 801: po_line_locations_all POLL

797: )
798: ),0)
799: INTO l_tax_amount
800: FROM po_distributions_all POD,
801: po_line_locations_all POLL
802: WHERE POD.po_header_id = POHdr_rec.po_header_id
803: AND POD.line_location_id=POLL.line_location_id
804: AND POD.po_header_id=POLL.po_header_id
805: AND Nvl(distribution_type,'STANDARD') NOT IN ('PREPAYMENT') -- 11876122

Line 1266: FROM po_line_locations

1262:
1263: ELSIF (doc_type_code = 'RELEASE') THEN
1264: SELECT shipment_type
1265: INTO l_doc_subtype
1266: FROM po_line_locations
1267: WHERE po_release_id = doc_header_id
1268: AND ROWNUM = 1;
1269:
1270: ELSIF (doc_type_code = 'REQUISITION') THEN

Line 1509: po_line_locations PLL,

1505: -- is necessary because even if no backing requisition lines were found,
1506: -- we still want to return POH.agent_id.
1507: SELECT PRL.to_person_id, POH.agent_id
1508: FROM po_lines POL,
1509: po_line_locations PLL,
1510: -- For Shared Procurement, the destination OU may be different from
1511: -- the Purchasing OU:
1512: po_requisition_lines_all PRL,
1513: po_headers POH

Line 1528: -- : Added join to po_line_locations and shipment_num

1524: -- distributions, starting with the first distribution that has a
1525: -- requester.
1526: -- SQL Why: To determine the recipient of the Temp Labor notification.
1527: --
1528: -- : Added join to po_line_locations and shipment_num
1529: -- to the ORDER BY clause so we will get the first distribution on the
1530: -- first pay item that has a deliver-to-person, in the case of a complex
1531: -- work PO that has multiple pay items on a fixed-price temp labor line.
1532: -- Changed po_distributions to po_distributions_all to only have a single

Line 1536: , po_line_locations PLL --

1532: -- Changed po_distributions to po_distributions_all to only have a single
1533: -- secured synonym in the query.
1534: SELECT POD.deliver_to_person_id
1535: FROM po_distributions_all POD
1536: , po_line_locations PLL --
1537: WHERE POD.line_location_id = PLL.line_location_id
1538: AND PLL.po_line_id = p_po_line_id
1539: AND POD.deliver_to_person_id IS NOT NULL
1540: AND PLL.shipment_type <> 'PREPAYMENT'

Line 1928: po_line_locations PLL,

1924: l_document_number,
1925: l_req_header_id
1926: FROM po_lines POL,
1927: po_headers POH,
1928: po_line_locations PLL,
1929: po_requisition_lines_all PRL
1930: WHERE POL.po_line_id = p_po_line_id
1931: AND POL.po_header_id = POH.po_header_id -- JOIN
1932: AND POL.po_line_id = PLL.po_line_id -- JOIN