eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_SUPERSESSIONS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 21: FROM MTL_SYSTEM_ITEMS_B

17:
18: CURSOR is_item_scrap(c_inventory_item_id NUMBER, c_org_id number)
19: IS
20: SELECT decode(MTL_TRANSACTIONS_ENABLED_FLAG,'Y','N','N','Y')
21: FROM MTL_SYSTEM_ITEMS_B
22: WHERE inventory_item_id = c_inventory_item_id
23: AND ORGANIZATION_ID = c_org_id;
24:
25: CURSOR get_replacing_item(c_master_org_id NUMBER, c_item_id NUMBER)

Line 116: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi

112:
113: CURSOR bilateral_relation_item(c_related_item_id number,c_master_org_id number,c_inventory_item_id number)
114: IS
115: select MRI.inventory_item_id
116: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi
117: where mri.ORGANIZATION_ID = c_master_org_id
118: and mri.RELATIONSHIP_TYPE_ID = 8
119: and mri.related_item_id = c_related_item_id
120: and mri.reciprocal_flag = 'Y'

Line 207: from mtl_system_items_b msib, csp_plan_reorders cpr

203:
204: CURSOR get_rop_for_org
205: IS
206: SELECT nvl(decode(cpr.newbuy_rop,0,null), NVL(MIN_MINMAX_QUANTITY,0))
207: from mtl_system_items_b msib, csp_plan_reorders cpr
208: where msib.organization_id = p_planned_org_id
209: and msib.inventory_item_id = l_inventory_item_Id
210: and cpr.organization_id = msib.organization_id
211: and cpr.inventory_item_id = msib.inventory_item_id ;

Line 213: from mtl_system_items_b

209: and msib.inventory_item_id = l_inventory_item_Id
210: and cpr.organization_id = msib.organization_id
211: and cpr.inventory_item_id = msib.inventory_item_id ;
212: /* SELECT NVL(MIN_MINMAX_QUANTITY,0)
213: from mtl_system_items_b
214: where organization_id = p_planned_org_id
215: and inventory_item_id = l_inventory_item_Id;*/
216:
217: CURSOR get_replacing_item(c_master_org_id NUMBER, c_item_id NUMBER)

Line 339: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi

335: END LOOP;
336: l_where_string := l_where_string || ')' ;
337: END IF;
338: l_sql_string := 'select MRI.inventory_item_id
339: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi
340: where mri.ORGANIZATION_ID =' || p_master_org_id ||
341: 'and mri.RELATIONSHIP_TYPE_ID = 8
342: and mri.related_item_id =' || l_inventory_item_id ||
343: 'and mri.reciprocal_flag =' || '''' || 'Y' || '''' ||

Line 678: from mtl_system_items_b

674:
675: CURSOR get_rop(c_item_id NUMBER, c_org_id NUMBER)
676: IS
677: /* SELECT NVL(MIN_MINMAX_QUANTITY,0)
678: from mtl_system_items_b
679: where organization_id = c_org_id
680: and inventory_item_id = c_item_id;*/
681: SELECT nvl(decode(cpr.newbuy_rop,0,null), NVL(MIN_MINMAX_QUANTITY,0))
682: from mtl_system_items_b msib, csp_plan_reorders cpr

Line 682: from mtl_system_items_b msib, csp_plan_reorders cpr

678: from mtl_system_items_b
679: where organization_id = c_org_id
680: and inventory_item_id = c_item_id;*/
681: SELECT nvl(decode(cpr.newbuy_rop,0,null), NVL(MIN_MINMAX_QUANTITY,0))
682: from mtl_system_items_b msib, csp_plan_reorders cpr
683: where msib.organization_id = c_org_id
684: and msib.inventory_item_id = c_item_id
685: and cpr.organization_id = msib.organization_id
686: and cpr.inventory_item_id = msib.inventory_item_id ;

Line 789: from mtl_system_items_b

785:
786: CURSOR get_rop
787: IS
788: /*SELECT NVL(MIN_MINMAX_QUANTITY,0)
789: from mtl_system_items_b
790: where organization_id = p_org_id
791: and inventory_item_id = p_item_id;*/
792: SELECT nvl(decode(cpr.newbuy_rop,0,null), NVL(MIN_MINMAX_QUANTITY,0))
793: from mtl_system_items_b msib, csp_plan_reorders cpr

Line 793: from mtl_system_items_b msib, csp_plan_reorders cpr

789: from mtl_system_items_b
790: where organization_id = p_org_id
791: and inventory_item_id = p_item_id;*/
792: SELECT nvl(decode(cpr.newbuy_rop,0,null), NVL(MIN_MINMAX_QUANTITY,0))
793: from mtl_system_items_b msib, csp_plan_reorders cpr
794: where msib.organization_id = p_org_id
795: and msib.inventory_item_id = p_item_id
796: and cpr.organization_id = msib.organization_id
797: and cpr.inventory_item_id = msib.inventory_item_id ;

Line 983: from MTL_RELATED_ITEMS mri,mtl_system_items_b msi

979: BUILD_NOT_IN_CONDITION(p_master_org_id,l_item_id, l_where_string);
980: END IF;
981: IF l_where_string IS NOT NULL THEN
982: l_sql_string := 'select mri.inventory_item_id
983: from MTL_RELATED_ITEMS mri,mtl_system_items_b msi
984: where mri.ORGANIZATION_ID = ' || p_org_id ||
985: 'and mri.RELATIONSHIP_TYPE_ID = 18
986: and mri.inventory_item_id <> ' || l_item_id ||
987: 'and mri.RELATED_ITEM_ID = ' || l_item_id ||

Line 995: from MTL_RELATED_ITEMS mri,mtl_system_items_b msi

991: MSI.MTL_TRANSACTIONS_ENABLED_FLAG =' || '''' || 'Y' || '''' ||
992: ' and msi.organization_id = mri.ORGANIZATION_ID' ;
993: ELSE
994: l_sql_string := 'select mri.inventory_item_id
995: from MTL_RELATED_ITEMS mri,mtl_system_items_b msi
996: where mri.ORGANIZATION_ID = ' || p_org_id ||
997: 'and mri.RELATIONSHIP_TYPE_ID = 18
998: and mri.inventory_item_id <> ' || l_item_id ||
999: 'and mri.RELATED_ITEM_ID = ' || l_item_id ||

Line 1148: FROM mtl_related_items mri, mtl_parameters mp, mtl_system_items_b msi

1144: IS
1145:
1146: CURSOR get_supersede_item(c_inventory_item_id NUMBER, c_organization_id NUMBER) IS
1147: SELECT mri.related_item_id
1148: FROM mtl_related_items mri, mtl_parameters mp, mtl_system_items_b msi
1149: WHERE mp.organization_id = c_organization_id
1150: AND mri.organization_id = mp.master_organization_id
1151: AND mri.inventory_item_id = c_inventory_item_id
1152: AND mri.RELATIONSHIP_TYPE_ID = 8

Line 1239: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi

1235: END IF;
1236: END LOOP;
1237: l_not_in_string := l_not_in_string || ')' ;
1238: l_sql_string := 'select MRI.inventory_item_id
1239: from MTL_RELATED_ITEMS mri , MTL_SYSTEM_ITEMS_B msi
1240: where mri.ORGANIZATION_ID =' || l_master_org ||
1241: 'and mri.RELATIONSHIP_TYPE_ID = 8
1242: and mri.related_item_id =' || p_inventory_item_id ||
1243: 'and mri.reciprocal_flag =' || '''' || 'Y' || '''' ||

Line 1444: from mtl_system_items_b_kfv

1440: and mriv.RELATIONSHIP_TYPE_ID = 8;
1441:
1442: cursor get_item_number(c_item_id number) IS
1443: select concatenated_segments
1444: from mtl_system_items_b_kfv
1445: where inventory_item_id = c_item_id
1446: and organization_id = cs_std.get_item_valdn_orgzn_id;
1447:
1448: