APPS.CSP_SCH_INT_PVT dependencies on MTL_RELATED_ITEMS

Line 3263: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

3259: AND ORDER_LINE_ID IS NOT NULL ;*/
3260:
3261: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
3262: SELECT mri.RELATED_ITEM_ID
3263: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
3264: WHERE mp.organization_id = org_id
3265: AND mri.INVENTORY_ITEM_ID = item_id
3266: AND mri.RELATIONSHIP_TYPE_ID = 2
3267: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;

Line 6202: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

6198: AND organization_id = org_id;
6199: CURSOR substitutes(item_id NUMBER,org_id NUMBER)
6200: IS
6201: /* SELECT mri.RELATED_ITEM_ID
6202: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
6203: WHERE mp.organization_id = org_id
6204: AND mri.INVENTORY_ITEM_ID = item_id
6205: AND mri.RELATIONSHIP_TYPE_ID = 2
6206: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/

Line 6208: FROM MTL_RELATED_ITEMS mri,

6204: AND mri.INVENTORY_ITEM_ID = item_id
6205: AND mri.RELATIONSHIP_TYPE_ID = 2
6206: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/
6207: SELECT mri.RELATED_ITEM_ID
6208: FROM MTL_RELATED_ITEMS mri,
6209: mtl_parameters mp
6210: WHERE mp.organization_id = org_id
6211: AND mri.INVENTORY_ITEM_ID = item_id
6212: AND mri.RELATIONSHIP_TYPE_ID = 2

Line 7764: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp

7760: AND organization_id = org_id;
7761:
7762: CURSOR substitutes(item_id NUMBER,org_id NUMBER) IS
7763: /* SELECT mri.RELATED_ITEM_ID
7764: FROM MTL_RELATED_ITEMS_VIEW mri, mtl_parameters mp
7765: WHERE mp.organization_id = org_id
7766: AND mri.INVENTORY_ITEM_ID = item_id
7767: AND mri.RELATIONSHIP_TYPE_ID = 2
7768: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/

Line 7770: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp

7766: AND mri.INVENTORY_ITEM_ID = item_id
7767: AND mri.RELATIONSHIP_TYPE_ID = 2
7768: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;*/
7769: SELECT mri.RELATED_ITEM_ID
7770: FROM MTL_RELATED_ITEMS mri, mtl_parameters mp
7771: WHERE mp.organization_id = org_id
7772: AND mri.INVENTORY_ITEM_ID = item_id
7773: AND mri.RELATIONSHIP_TYPE_ID = 2
7774: AND mri.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID;