APPS.RRS_ASSETS_PKG dependencies on CSI_II_RELATIONSHIPS

Line 28: FROM CSI_II_RELATIONSHIPS cii,

24: SELECT cii.SUBJECT_ID
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)

Line 41: FROM CSI_II_RELATIONSHIPS cii,

37:
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)

Line 56: AND NOT EXISTS (SELECT 1 FROM CSI_II_RELATIONSHIPS CII WHERE CII.SUBJECT_ID = CSI.INSTANCE_ID) ;

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:
59:
60: l_return_status VARCHAR2(1);

Line 203: CSI_II_RELATIONSHIPS_PUB.GET_RELATIONSHIPS

199: l_relationship_query_rec.OBJECT_ID := rec.SUBJECT_ID;
200: l_relationship_query_rec.RELATIONSHIP_TYPE_CODE := 'COMPONENT-OF';
201:
202: IF l_exists_flag = 'N' THEN
203: CSI_II_RELATIONSHIPS_PUB.GET_RELATIONSHIPS
204: (
205: p_api_version => 1.0
206: ,p_commit => fnd_api.g_false
207: ,p_init_msg_list => fnd_api.g_false

Line 234: CSI_II_RELATIONSHIPS_PUB.CREATE_RELATIONSHIP

230:
231: l_transaction_rec.source_transaction_date := sysdate ;
232: l_transaction_rec.transaction_type_id := 1 ;
233:
234: CSI_II_RELATIONSHIPS_PUB.CREATE_RELATIONSHIP
235: (
236: p_api_version => 1.0
237: ,p_commit => fnd_api.g_false
238: ,p_init_msg_list => fnd_api.g_false