APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_LINE_LOCATIONS

Line 3223: FROM po_line_locations PLL

3219: FROM po_lines_all POL2,
3220: per_jobs_vl PJ,
3221: ( SELECT PLL.po_line_id
3222: , SUM(PLL.amount_billed) total_amount_billed
3223: FROM po_line_locations PLL
3224: , po_lines_all POL
3225: , po_headers_all poh
3226: WHERE poh.type_lookup_code = 'STANDARD'
3227: AND poh.po_header_id = POL.po_header_id

Line 3524: po_line_locations_all PLL,

3520:
3521: select PRL.requisition_header_id
3522: INTO l_req_header_id
3523: FROM po_lines POL,
3524: po_line_locations_all PLL,
3525: po_requisition_lines_all PRL
3526: WHERE POL.po_line_id = p_po_line_id
3527: AND POL.po_line_id = PLL.po_line_id
3528: AND PLL.line_location_id = PRL.line_location_id;