APPS.CSM_DEBRIEF_PARTS_PKG dependencies on CSI_ITEM_INSTANCES

Line 44: FROM CSI_ITEM_INSTANCES cii,

40: cii.INVENTORY_REVISION,
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;

Line 59: FROM CSI_ITEM_INSTANCES cii,

55: cii.INVENTORY_REVISION,
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;