APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_LINES_INTERFACE

Line 237: po_lines_interface pli,

233: AND pui.attr_group_type = 'PO_HEADER_EXT_ATTRS'
234: UNION
235: SELECT pui.interface_line_id
236: FROM po_headers_interface phi,
237: po_lines_interface pli,
238: po_uda_interface pui
239: WHERE phi.interface_header_id = p_interface_header_id
240: AND pli.interface_header_id = phi.interface_header_id
241: AND pli.interface_line_id = pui.interface_reference_id

Line 246: po_lines_interface pli,

242: AND pui.attr_group_type = 'PO_LINE_EXT_ATTRS'
243: UNION
244: SELECT pui.interface_line_id
245: FROM po_headers_interface phi,
246: po_lines_interface pli,
247: po_line_locations_interface pll,
248: po_uda_interface pui
249: WHERE phi.interface_header_id = p_interface_header_id
250: AND pli.interface_header_id = phi.interface_header_id

Line 342: FROM po_lines_interface

338: SET pk1_value = Decode(attr_group_type, 'PO_HEADER_EXT_ATTRS', (SELECT po_header_id
339: FROM po_headers_interface
340: WHERE interface_header_id = interface_reference_id ),
341: 'PO_LINE_EXT_ATTRS' , (SELECT PO_LINE_ID
342: FROM po_lines_interface
343: WHERE interface_line_id = interface_reference_id),
344: 'PO_SHIPMENTS_EXT_ATTRS' , (SELECT LINE_LOCATION_ID
345: FROM PO_LINE_LOCATIONS_INTERFACE
346: WHERE interface_line_location_id = interface_reference_id)

Line 2786: po_lines_interface PLI,

2782: x_lines.sourcing_rule_name_tbl,
2783: x_lines.effective_date_tbl,
2784: x_lines.expiration_date_tbl
2785: FROM po_headers_interface PHI,
2786: po_lines_interface PLI,
2787: po_lines_draft_all PLD
2788: WHERE PHI.interface_header_id = p_doc_rec.interface_header_id
2789: AND PHI.interface_header_id = PLI.interface_header_id
2790: AND PHI.draft_id = PLD.draft_id