eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_PARTY_DATA_EVENT_PKG dependencies on CSM_ITEM_INSTANCES_ACC

Line 24: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';

20: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
23:
24: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
27: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');

Line 25: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';

21: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
22: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_LOCATIONS');
23:
24: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
27: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
28: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
29:

Line 92: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;

88: TYPE l_party_id_tbl_type IS TABLE OF csm_parties_acc.party_id%TYPE INDEX BY BINARY_INTEGER;
89: TYPE l_user_id_tbl_type IS TABLE OF csm_parties_acc.user_id%TYPE INDEX BY BINARY_INTEGER;
90: TYPE l_party_site_id_tbl_type IS TABLE OF csm_party_sites_acc.party_site_id%TYPE INDEX BY BINARY_INTEGER;
91: TYPE l_location_id_tbl_type IS TABLE OF csm_hz_locations_acc.location_id%TYPE INDEX BY BINARY_INTEGER;
92: TYPE l_instance_id_tbl_type IS TABLE OF csm_item_instances_acc.instance_id%TYPE INDEX BY BINARY_INTEGER;
93: TYPE l_contacts_id_tbl_type IS TABLE OF csm_sr_contacts_acc.sr_contact_point_id%TYPE INDEX BY BINARY_INTEGER;
94: TYPE l_cust_acct_id_tbl_type IS TABLE OF csm_hz_cust_accounts_acc.cust_account_id%TYPE INDEX BY BINARY_INTEGER;
95: TYPE l_counter_id_tbl_type IS TABLE OF csm_counters_acc.counter_id%TYPE INDEX BY BINARY_INTEGER;
96: TYPE l_counter_value_id_tbl_type IS TABLE OF csm_counter_values_acc.counter_value_id%TYPE INDEX BY BINARY_INTEGER;

Line 207: FROM csm_item_instances_acc ciia

203: AND TRUNC(NVL(civ.active_end_date,SYSDATE)))
204: AND CII.INSTANCE_ID = CIR.SUBJECT_ID(+)
205: AND CIR.RELATIONSHIP_TYPE_CODE(+) = 'COMPONENT-OF'
206: AND NOT EXISTS ( SELECT 1
207: FROM csm_item_instances_acc ciia
208: WHERE ciia.instance_id = cii.instance_id
209: AND ciia.user_id = tcpa.user_id
210: )
211: UNION

Line 234: FROM csm_item_instances_acc ciia

230: AND TRUNC(NVL(civ.active_end_date,SYSDATE)))
231: AND CII.INSTANCE_ID = CIR.SUBJECT_ID(+)
232: AND CIR.RELATIONSHIP_TYPE_CODE(+) = 'COMPONENT-OF'
233: AND NOT EXISTS ( SELECT 1
234: FROM csm_item_instances_acc ciia
235: WHERE ciia.user_id = cpa.user_id
236: );
237:
238: /*

Line 248: , csm_item_instances_acc ciia

244: SELECT ccb.counter_id
245: , ciia.user_id
246: FROM csi_counters_b ccb
247: , csi_counter_associations cca
248: , csm_item_instances_acc ciia
249: WHERE ccb.counter_id = cca.counter_id
250: AND cca.source_object_id = ciia.instance_id
251: AND ccb.counter_type = 'REGULAR'
252: AND cca.source_object_code = 'CP'

Line 437: FROM csm_item_instances_acc ciia

433: AND (tcpa.party_site_id = -1
434: OR tcpa.party_site_id = cpsa.party_site_id)
435: AND tcpa.deleted_flag = 'Y'
436: AND EXISTS ( SELECT 1
437: FROM csm_item_instances_acc ciia
438: WHERE ciia.instance_id = cii.instance_id
439: AND ciia.user_id = tcpa.user_id
440: )
441: UNION

Line 455: FROM csm_item_instances_acc ciia

451: AND cii.location_type_code = 'HZ_LOCATIONS'
452: AND cpa.party_site_id IN (-1,-2)
453: AND cpa.deleted_flag = 'Y'
454: AND EXISTS ( SELECT 1
455: FROM csm_item_instances_acc ciia
456: WHERE ciia.user_id = cpa.user_id
457: );
458:
459: /*

Line 475: FROM csm_item_instances_acc ciia

471: AND ccb.counter_type = 'REGULAR'
472: AND cca.source_object_code = 'CP'
473: AND ccsa.counter_id = ccb.counter_id
474: AND NOT EXISTS (SELECT 1
475: FROM csm_item_instances_acc ciia
476: WHERE cca.source_object_id = ciia.instance_id
477: AND ccsa.user_id = ciia.user_id
478: );
479:

Line 771: --call the CSM_ACC_PKG to delete the record from csm_item_instances_acc table

767: IF l_instance_id_tbl.COUNT > 0 THEN
768:
769: FOR i IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST LOOP
770:
771: --call the CSM_ACC_PKG to delete the record from csm_item_instances_acc table
772:
773: CSM_ACC_PKG.Delete_Acc
774: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
775: ,P_ACC_TABLE_NAME => g_acc_table_name3

Line 1305: --call the CSM_ACC_PKG to insert into csm_item_instances_acc table

1301: IF l_instance_id_tbl.COUNT > 0 THEN
1302:
1303: FOR i IN l_instance_id_tbl.FIRST..l_instance_id_tbl.LAST LOOP
1304:
1305: --call the CSM_ACC_PKG to insert into csm_item_instances_acc table
1306:
1307: CSM_ACC_PKG.Insert_Acc
1308: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name3
1309: ,P_ACC_TABLE_NAME => g_acc_table_name3

Line 1316: UPDATE csm_item_instances_acc

1312: ,P_PK1_NUM_VALUE => l_instance_id_tbl(i)
1313: ,P_USER_ID => l_user_id_tbl(i)
1314: );
1315:
1316: UPDATE csm_item_instances_acc
1317: SET PARENT_INSTANCE_ID = l_parent_inst_id_lst(i),
1318: VERSION_LABEL = l_ver_label_lst(i)
1319: WHERE USER_ID = l_user_id_tbl(i)
1320: AND INSTANCE_ID = l_instance_id_tbl(i);