APPS.RCV_ROI_HEADER_COMMON dependencies on MTL_RELATED_ITEMS

Line 1780: FROM mtl_related_items

1776: -- = 1 for related items
1777:
1778: /* SELECT NVL(MAX(inventory_item_id), 0)
1779: INTO x_inventory_item
1780: FROM mtl_related_items
1781: WHERE inventory_item_id = (SELECT item_id
1782: FROM po_lines
1783: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1784: AND related_item_id = x_cascaded_table(n).substitute_item_id

Line 1793: FROM mtl_related_items mri,

1789: -- Bugfix 5219284, Above query is replaced by following query for performance issues.
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

Line 1807: FROM mtl_related_items

1803: -- Try the reciprocal relationship
1804:
1805: /* SELECT NVL(MAX(inventory_item_id), 0)
1806: INTO x_inventory_item
1807: FROM mtl_related_items
1808: WHERE related_item_id = (SELECT item_id
1809: FROM po_lines
1810: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1811: AND inventory_item_id = x_cascaded_table(n).substitute_item_id

Line 1820: FROM mtl_related_items mri,

1816: -- Bugfix 5219284, Above query is replaced by following query for performance issues.
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