APPS.CSICUMPI_PUB dependencies on CSI_ITEM_INSTANCES

Line 68: FROM CSI_ITEM_INSTANCES CII,

64: CII.SERIAL_NUMBER SERIAL,
65: CII.LOT_NUMBER LOT,
66: MSIK.CONCATENATED_SEGMENTS PRODUCT,
67: MSIK.DESCRIPTION DESCRIPTION
68: FROM CSI_ITEM_INSTANCES CII,
69: MTL_SYSTEM_ITEMS_KFV MSIK
70: WHERE MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
71: AND CII.INSTANCE_ID = P_INSTANCE_ID
72: AND MSIK.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID;

Line 111: FROM CSI_Item_Instances CII,

107: MSIK.DESCRIPTION,
108: CII.Instance_Number,
109: CII.Serial_Number,
110: CII.Lot_Number
111: FROM CSI_Item_Instances CII,
112: MTL_SYSTEM_ITEMS_KFV MSIK
113: WHERE CII.Instance_Id = P_Customer_Product_Id
114: AND CII.Inventory_Item_Id = MSIK.Inventory_Item_ID
115: AND CII.Inv_Master_Organization_Id = MSIK.Organization_Id;

Line 194: FROM CSI_ITEM_INSTANCES CII,

190: CII.OWNER_PARTY_ACCOUNT_ID,
191: CII.INVENTORY_ITEM_ID,
192: CII.SERIAL_NUMBER,
193: CII.LOT_NUMBER
194: FROM CSI_ITEM_INSTANCES CII,
195: CSI_II_RELATIONSHIPS CIIR
196: WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID
197: AND l_AS_OF_DATE BETWEEN NVL(CIIR.ACTIVE_START_DATE,l_As_Of_Date-1) AND NVL(CIIR.ACTIVE_END_DATE,l_As_Of_Date+1)
198: CONNECT BY PRIOR CIIR.SUBJECT_ID = CIIR.OBJECT_ID;

Line 245: FROM csi_Item_Instances

241: SELECT Instance_Number,
242: serial_number
243: INTO l_reference_number,
244: l_curr_serial_number
245: FROM csi_Item_Instances
246: WHERE Instance_id = c1.customer_product_id;
247:
248: l_config_tbl.DELETE;
249: l_config_tbl_count := 0;

Line 267: FROM csi_Item_Instances

263: SELECT Instance_Number,
264: serial_number
265: INTO l_reference_number,
266: l_curr_serial_number
267: FROM csi_Item_Instances
268: WHERE Instance_id = c1.customer_product_id;
269:
270: l_config_tbl.DELETE;
271: l_config_tbl_count := 0;