APPS.RRS_ASSETS_PKG dependencies on CSI_ITEM_INSTANCES

Line 29: CSI_ITEM_INSTANCES csi

25: ,csi.INVENTORY_ITEM_ID
26: ,csi.LAST_VLD_ORGANIZATION_ID
27: ,LEVEL
28: FROM CSI_II_RELATIONSHIPS cii,
29: CSI_ITEM_INSTANCES csi
30: WHERE cii.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
31: AND cii.SUBJECT_ID = csi.INSTANCE_ID
32: AND TRUNC(NVL(cii.ACTIVE_START_DATE , SYSDATE)) <= TRUNC(SYSDATE)
33: AND TRUNC(NVL(cii.ACTIVE_END_DATE , SYSDATE )) >= TRUNC(SYSDATE)

Line 42: CSI_ITEM_INSTANCES csi

38: CURSOR OBJECT_ID_CURS(c_subject_id NUMBER) IS
39: SELECT cii.SUBJECT_ID OBJECT_ID
40: ,csi.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
41: FROM CSI_II_RELATIONSHIPS cii,
42: CSI_ITEM_INSTANCES csi
43: WHERE cii.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
44: AND cii.OBJECT_ID = csi.INSTANCE_ID
45: AND TRUNC(NVL(cii.ACTIVE_START_DATE , SYSDATE)) <= TRUNC(SYSDATE)
46: AND TRUNC(NVL(cii.ACTIVE_END_DATE , SYSDATE )) >= TRUNC(SYSDATE)

Line 54: FROM CSI_ITEM_INSTANCES CSI

50:
51: CURSOR LEVEL_ONE_ASSET_INSTANCES(c_party_site_id NUMBER) IS
52: SELECT CSI.INSTANCE_ID
53: ,CSI.INVENTORY_ITEM_ID
54: FROM CSI_ITEM_INSTANCES CSI
55: WHERE LOCATION_ID = c_party_site_id
56: AND NOT EXISTS (SELECT 1 FROM CSI_II_RELATIONSHIPS CII WHERE CII.SUBJECT_ID = CSI.INSTANCE_ID) ;
57:
58:

Line 143: FROM CSI_ITEM_INSTANCES csi

139: SELECT 'Y'
140: INTO l_exists_flag
141: FROM DUAL
142: WHERE EXISTS ( SELECT 'Y'
143: FROM CSI_ITEM_INSTANCES csi
144: WHERE csi.location_id = l_party_site_id
145: --AND csi.instance_id = rec.subject_id Bug#4548344
146: AND csi.inventory_item_id = rec.inventory_item_id --csi.inventory_item_id
147: AND csi.last_vld_organization_id = rec.last_vld_organization_id