APPS.CSM_DEBRIEF_PARTS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 31: FROM MTL_SYSTEM_ITEMS_B

27:
28: CURSOR c_get_item_id(c_item_name VARCHAR2, c_org_id NUMBER)
29: IS
30: SELECT INVENTORY_ITEM_ID,MATERIAL_BILLABLE_FLAG,PRIMARY_UOM_CODE
31: FROM MTL_SYSTEM_ITEMS_B
32: WHERE UPPER(SEGMENT1) = UPPER(c_item_name)
33: AND ORGANIZATION_ID = c_org_id;
34:
35: CURSOR c_serial_item(c_serial_number VARCHAR2, c_org_id NUMBER)

Line 45: MTL_SYSTEM_ITEMS_B msi

41: msi.INVENTORY_ITEM_ID,
42: msi.MATERIAL_BILLABLE_FLAG,
43: msi.PRIMARY_UOM_CODE
44: FROM CSI_ITEM_INSTANCES cii,
45: MTL_SYSTEM_ITEMS_B msi
46: WHERE UPPER(SERIAL_NUMBER) = UPPER(c_serial_number)
47: AND msi.inventory_item_id = cii.inventory_item_id
48: AND msi.organization_id = c_org_id;
49:

Line 60: MTL_SYSTEM_ITEMS_B msi

56: msi.INVENTORY_ITEM_ID,
57: msi.MATERIAL_BILLABLE_FLAG,
58: msi.PRIMARY_UOM_CODE
59: FROM CSI_ITEM_INSTANCES cii,
60: MTL_SYSTEM_ITEMS_B msi
61: WHERE UPPER(INSTANCE_NUMBER) = UPPER(c_inst_number)
62: AND msi.inventory_item_id = cii.inventory_item_id
63: AND msi.organization_id = c_org_id;
64: