DBA Data[Home] [Help]

APPS.RCV_ROI_HEADER_COMMON dependencies on PO_LINES_ALL

Line 1794: po_lines_all pl

1790:
1791: SELECT NVL(MAX(inventory_item_id), 0)
1792: INTO x_inventory_item
1793: FROM mtl_related_items mri,
1794: po_lines_all pl
1795: WHERE mri.inventory_item_id = pl.item_id
1796: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1797: AND mri.related_item_id = x_cascaded_table(n).substitute_item_id
1798: AND mri.relationship_type_id = 2; -- substitute items

Line 1821: po_lines_all pl

1817:
1818: SELECT NVL(MAX(inventory_item_id), 0)
1819: INTO x_inventory_item
1820: FROM mtl_related_items mri,
1821: po_lines_all pl
1822: WHERE mri.related_item_id = pl.item_id
1823: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1824: AND mri.inventory_item_id = x_cascaded_table(n).substitute_item_id
1825: AND mri.reciprocal_flag = 'Y'