APPS.CSICUMPI_PUB dependencies on CSI_II_RELATIONSHIPS

Line 58: FROM CSI_II_RELATIONSHIPS CIR

54: l_Result_String VARCHAR2(2000);
55: l_Token CONSTANT VARCHAR2(4) := '@$?!';
56: CURSOR Root_Cur (P_Object_ID IN NUMBER) IS
57: SELECT CIR.OBJECT_ID
58: FROM CSI_II_RELATIONSHIPS CIR
59: START WITH Object_Id = P_Object_ID
60: CONNECT BY PRIOR OBJECT_ID = SUBJECT_ID
61: ORDER BY OBJECT_ID;
62: CURSOR Instance_Cur (P_Instance_ID IN NUMBER) IS

Line 151: FROM CSI_II_RELATIONSHIPS

147: RETURN VARCHAR2 IS
148:
149: CURSOR c1 IS
150: SELECT Subject_ID
151: FROM CSI_II_RELATIONSHIPS
152: WHERE OBJECT_ID = P_Customer_Product_Id
153: AND ACTIVE_END_DATE IS NULL;
154:
155: l_cp_id NUMBER;

Line 195: CSI_II_RELATIONSHIPS CIIR

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;
199:

Line 285: FROM CSI_II_RELATIONSHIPS CIR

281: RETURN NUMBER IS
282:
283: CURSOR Root_Cur (P_Object_ID IN NUMBER) IS
284: SELECT CIR.OBJECT_ID
285: FROM CSI_II_RELATIONSHIPS CIR
286: START WITH Object_Id = P_Object_ID
287: CONNECT BY PRIOR OBJECT_ID = SUBJECT_ID
288: ORDER BY OBJECT_ID;
289: l_Root_Id NUMBER;