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 1034: FROM po_line_locations

1030:
1031: ELSIF (doc_type_code = 'RELEASE') THEN
1032: SELECT shipment_type
1033: INTO l_doc_subtype
1034: FROM po_line_locations
1035: WHERE po_release_id = doc_header_id
1036: AND ROWNUM = 1;
1037:
1038: ELSIF (doc_type_code = 'REQUISITION') THEN

Line 1277: po_line_locations PLL,

1273: -- is necessary because even if no backing requisition lines were found,
1274: -- we still want to return POH.agent_id.
1275: SELECT PRL.to_person_id, POH.agent_id
1276: FROM po_lines POL,
1277: po_line_locations PLL,
1278: -- For Shared Procurement, the destination OU may be different from
1279: -- the Purchasing OU:
1280: po_requisition_lines_all PRL,
1281: po_headers POH

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

1292: -- distributions, starting with the first distribution that has a
1293: -- requester.
1294: -- SQL Why: To determine the recipient of the Temp Labor notification.
1295: --
1296: -- : Added join to po_line_locations and shipment_num
1297: -- to the ORDER BY clause so we will get the first distribution on the
1298: -- first pay item that has a deliver-to-person, in the case of a complex
1299: -- work PO that has multiple pay items on a fixed-price temp labor line.
1300: -- Changed po_distributions to po_distributions_all to only have a single

Line 1304: , po_line_locations PLL --

1300: -- Changed po_distributions to po_distributions_all to only have a single
1301: -- secured synonym in the query.
1302: SELECT POD.deliver_to_person_id
1303: FROM po_distributions_all POD
1304: , po_line_locations PLL --
1305: WHERE POD.line_location_id = PLL.line_location_id
1306: AND PLL.po_line_id = p_po_line_id
1307: AND POD.deliver_to_person_id IS NOT NULL
1308: AND PLL.shipment_type <> 'PREPAYMENT'

Line 1677: po_line_locations PLL,

1673: l_document_number,
1674: l_req_header_id
1675: FROM po_lines POL,
1676: po_headers POH,
1677: po_line_locations PLL,
1678: po_requisition_lines_all PRL
1679: WHERE POL.po_line_id = p_po_line_id
1680: AND POL.po_header_id = POH.po_header_id -- JOIN
1681: AND POL.po_line_id = PLL.po_line_id -- JOIN