DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on PO_LINES_ALL

Line 153: from po_doc_style_headers st, po_headers_all poh, po_lines_all pol

149: select nvl(clm_flag,'N'), nvl(LINE_NUM_DISPLAY,'XXXX'), to_char(line_num)
150: into v_clm_flag,
151: v_clm_line_num,
152: v_line_num
153: from po_doc_style_headers st, po_headers_all poh, po_lines_all pol
154: where poh.style_id=st.style_id
155: and poh.po_header_id= pol.po_header_id
156: and pol.po_line_id=p_po_line_id;
157:

Line 346: po_lines_all pol,

342: ) OR
343: ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
344: AND EXISTS (SELECT 'X'
345: FROM mtl_system_items si,
346: po_lines_all pol,
347: po_distributions_all po_dist1
348: WHERE po_dist1.po_line_id = pol.po_line_id
349: AND po_dist1.po_distribution_id = rcv_txn.po_distribution_id
350: AND si.inventory_item_id = pol.item_id