DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on PO_LINES_ALL

Line 4292: from po_lines_all pla

4288: AND b.item_id = a.inventory_item_id
4289: --bug5708184,in PO Source,add the condition to match with po supplier item.
4290: AND (a.concatenated_segments LIKE (p_concatenated_segments||l_append)
4291: or exists (select pla.vendor_product_num
4292: from po_lines_all pla
4293: where pla.po_header_id=b.po_header_id and
4294: pla.po_line_id=b.po_line_id and
4295: pla.vendor_product_num like (p_concatenated_segments)))
4296: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('PO',

Line 4679: from po_lines_all pla

4675: AND b.item_id = a.inventory_item_id
4676: --bug5708184,in Receitp source,add the condition to match with po supplier item
4677: AND (a.concatenated_segments LIKE (p_concatenated_segments||l_append)
4678: or exists (select pla.vendor_product_num
4679: from po_lines_all pla
4680: where pla.po_header_id=b.po_header_id and
4681: pla.po_line_id=b.po_line_id and
4682: pla.vendor_product_num like (p_concatenated_segments)))
4683: AND (inv_rcv_std_inspect_apis.get_inspection_qty_wrapper('RECEIPT',