APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_LINE_LOCATIONS

Line 3257: FROM po_line_locations PLL

3253: FROM po_lines_all POL2,
3254: per_jobs_vl PJ,
3255: ( SELECT PLL.po_line_id
3256: , SUM(PLL.amount_billed) total_amount_billed
3257: FROM po_line_locations PLL
3258: , po_lines_all POL
3259: , po_headers_all poh
3260: WHERE poh.type_lookup_code = 'STANDARD'
3261: AND poh.po_header_id = POL.po_header_id

Line 3558: po_line_locations_all PLL,

3554:
3555: select PRL.requisition_header_id
3556: INTO l_req_header_id
3557: FROM po_lines POL,
3558: po_line_locations_all PLL,
3559: po_requisition_lines_all PRL
3560: WHERE POL.po_line_id = p_po_line_id
3561: AND POL.po_line_id = PLL.po_line_id
3562: AND PLL.line_location_id = PRL.line_location_id;