1687: -- = 1 for related items
1688:
1689: /* SELECT NVL(MAX(inventory_item_id), 0)
1690: INTO x_inventory_item
1691: FROM mtl_related_items
1692: WHERE inventory_item_id = (SELECT item_id
1693: FROM po_lines
1694: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1695: AND related_item_id = x_cascaded_table(n).substitute_item_id
1700: -- Bugfix 5219284, Above query is replaced by following query for performance issues.
1701:
1702: SELECT NVL(MAX(inventory_item_id), 0)
1703: INTO x_inventory_item
1704: FROM mtl_related_items mri,
1705: po_lines_all pl
1706: WHERE mri.inventory_item_id = pl.item_id
1707: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1708: AND mri.related_item_id = x_cascaded_table(n).substitute_item_id
1714: -- Try the reciprocal relationship
1715:
1716: /* SELECT NVL(MAX(inventory_item_id), 0)
1717: INTO x_inventory_item
1718: FROM mtl_related_items
1719: WHERE related_item_id = (SELECT item_id
1720: FROM po_lines
1721: WHERE po_line_id = x_cascaded_table(n).po_line_id)
1722: AND inventory_item_id = x_cascaded_table(n).substitute_item_id
1727: -- Bugfix 5219284, Above query is replaced by following query for performance issues.
1728:
1729: SELECT NVL(MAX(inventory_item_id), 0)
1730: INTO x_inventory_item
1731: FROM mtl_related_items mri,
1732: po_lines_all pl
1733: WHERE mri.related_item_id = pl.item_id
1734: AND pl.po_line_id = x_cascaded_table(n).po_line_id
1735: AND mri.inventory_item_id = x_cascaded_table(n).substitute_item_id