APPS.CSP_SCH_INT_PVT dependencies on MTL_RELATED_ITEMS

Line 1573: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

1569: AND ORDER_LINE_ID IS NOT NULL ;*/
1570:
1571: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
1572: SELECT mri.RELATED_ITEM_ID
1573: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
1574: WHERE mp.organization_id = org_id
1575: AND mri.INVENTORY_ITEM_ID = item_id
1576: AND mri.RELATIONSHIP_TYPE_ID = 2
1577: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 3762: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

3758: AND organization_id = org_id;
3759:
3760: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
3761: /* SELECT mri.RELATED_ITEM_ID
3762: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
3763: WHERE mp.organization_id = org_id
3764: AND mri.INVENTORY_ITEM_ID = item_id
3765: AND mri.RELATIONSHIP_TYPE_ID = 2
3766: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/

Line 3768: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp

3764: AND mri.INVENTORY_ITEM_ID = item_id
3765: AND mri.RELATIONSHIP_TYPE_ID = 2
3766: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/
3767: SELECT mri.RELATED_ITEM_ID
3768: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp
3769: WHERE mp.organization_id = org_id
3770: AND mri.INVENTORY_ITEM_ID = item_id
3771: AND mri.RELATIONSHIP_TYPE_ID = 2
3772: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 5222: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

5218: AND organization_id = org_id;
5219:
5220: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
5221: /* SELECT mri.RELATED_ITEM_ID
5222: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
5223: WHERE mp.organization_id = org_id
5224: AND mri.INVENTORY_ITEM_ID = item_id
5225: AND mri.RELATIONSHIP_TYPE_ID = 2
5226: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/

Line 5228: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp

5224: AND mri.INVENTORY_ITEM_ID = item_id
5225: AND mri.RELATIONSHIP_TYPE_ID = 2
5226: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/
5227: SELECT mri.RELATED_ITEM_ID
5228: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp
5229: WHERE mp.organization_id = org_id
5230: AND mri.INVENTORY_ITEM_ID = item_id
5231: AND mri.RELATIONSHIP_TYPE_ID = 2
5232: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;