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.CSTPPCIC dependencies on MTL_ITEM_CATEGORIES

Line 557: FROM mtl_item_categories MIC

553: (p_range = 2 AND CICD.inventory_item_id = p_specific_item_id)
554: OR
555: EXISTS
556: (SELECT NULL
557: FROM mtl_item_categories MIC
558: WHERE MIC.organization_id = l_master_org_id
559: AND MIC.category_id = p_category_id
560: AND MIC.category_set_id = p_category_set_id
561: AND MIC.inventory_item_id = CICD.inventory_item_id

Line 612: FROM mtl_item_categories MIC

608: (p_range = 2 AND CIC.inventory_item_id = p_specific_item_id)
609: OR
610: EXISTS
611: (SELECT NULL
612: FROM mtl_item_categories MIC
613: WHERE MIC.organization_id = l_master_org_id
614: AND MIC.category_id = p_category_id
615: AND MIC.category_set_id = p_category_set_id
616: AND MIC.inventory_item_id = CIC.inventory_item_id

Line 644: FROM mtl_item_categories MIC

640: (p_range = 2 AND CIC.inventory_item_id = p_specific_item_id)
641: OR
642: EXISTS
643: (SELECT NULL
644: FROM mtl_item_categories MIC
645: WHERE MIC.organization_id = l_master_org_id
646: AND MIC.category_id = p_category_id
647: AND MIC.category_set_id = p_category_set_id
648: AND MIC.inventory_item_id = CIC.inventory_item_id

Line 806: FROM mtl_item_categories MIC

802: (p_range = 2 AND CPIC.inventory_item_id = p_specific_item_id)
803: OR
804: EXISTS
805: (SELECT NULL
806: FROM mtl_item_categories MIC
807: WHERE MIC.organization_id = l_master_org_id
808: AND MIC.category_id = p_category_id
809: AND MIC.category_set_id = p_category_set_id
810: AND MIC.inventory_item_id = CPIC.inventory_item_id

Line 912: FROM mtl_item_categories MIC

908: (p_range = 2 AND CPIC.inventory_item_id = p_specific_item_id)
909: OR
910: EXISTS
911: (SELECT NULL
912: FROM mtl_item_categories MIC
913: WHERE MIC.organization_id = l_master_org_id
914: AND MIC.category_id = p_category_id
915: AND MIC.category_set_id = p_category_set_id
916: AND MIC.inventory_item_id = CPIC.inventory_item_id

Line 1081: FROM mtl_item_categories MIC

1077: (p_range = 2 AND CPIC.inventory_item_id = p_specific_item_id)
1078: OR
1079: EXISTS
1080: (SELECT NULL
1081: FROM mtl_item_categories MIC
1082: WHERE MIC.organization_id = l_master_org_id
1083: AND MIC.category_id = p_category_id
1084: AND MIC.category_set_id = p_category_set_id
1085: AND MIC.inventory_item_id = CPIC.inventory_item_id

Line 1185: FROM mtl_item_categories MIC

1181: (p_range = 2 AND CPIC.inventory_item_id = p_specific_item_id)
1182: OR
1183: EXISTS
1184: (SELECT NULL
1185: FROM mtl_item_categories MIC
1186: WHERE MIC.organization_id = l_master_org_id
1187: AND MIC.category_id = p_category_id
1188: AND MIC.category_set_id = p_category_set_id
1189: AND MIC.inventory_item_id = CPIC.inventory_item_id

Line 1251: FROM mtl_item_categories MIC

1247: (p_range = 2 AND CICD.inventory_item_id = p_specific_item_id)
1248: OR
1249: EXISTS
1250: (SELECT NULL
1251: FROM mtl_item_categories MIC
1252: WHERE MIC.organization_id = l_master_org_id
1253: AND MIC.category_id = p_category_id
1254: AND MIC.category_set_id = p_category_set_id
1255: AND MIC.inventory_item_id = CICD.inventory_item_id

Line 1298: FROM mtl_item_categories MIC

1294: (p_range = 2 AND CIC.inventory_item_id = p_specific_item_id)
1295: OR
1296: EXISTS
1297: (SELECT NULL
1298: FROM mtl_item_categories MIC
1299: WHERE MIC.organization_id = l_master_org_id
1300: AND MIC.category_id = p_category_id
1301: AND MIC.category_set_id = p_category_set_id
1302: AND MIC.inventory_item_id = CIC.inventory_item_id

Line 1331: FROM mtl_item_categories MIC

1327: (p_range = 2 AND CIC.inventory_item_id = p_specific_item_id)
1328: OR
1329: EXISTS
1330: (SELECT NULL
1331: FROM mtl_item_categories MIC
1332: WHERE MIC.organization_id = l_master_org_id
1333: AND MIC.category_id = p_category_id
1334: AND MIC.category_set_id = p_category_set_id
1335: AND MIC.inventory_item_id = CIC.inventory_item_id

Line 1487: FROM mtl_item_categories MIC

1483: (p_range = 2 AND CPIC.inventory_item_id = p_specific_item_id)
1484: OR
1485: EXISTS
1486: (SELECT NULL
1487: FROM mtl_item_categories MIC
1488: WHERE MIC.organization_id = l_master_org_id
1489: AND MIC.category_id = p_category_id
1490: AND MIC.category_set_id = p_category_set_id
1491: AND MIC.inventory_item_id = CPIC.inventory_item_id

Line 1594: FROM mtl_item_categories MIC

1590: (p_range = 2 AND CPIC.inventory_item_id = p_specific_item_id)
1591: OR
1592: EXISTS
1593: (SELECT NULL
1594: FROM mtl_item_categories MIC
1595: WHERE MIC.organization_id = l_master_org_id
1596: AND MIC.category_id = p_category_id
1597: AND MIC.category_set_id = p_category_set_id
1598: AND MIC.inventory_item_id = CPIC.inventory_item_id