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_ITEM_INSTANCE_EVENT_PKG dependencies on CSI_ITEM_INSTANCES

Line 14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';

10: -- Person Date Comments
11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');

Line 141: FROM csi_item_instances cii

137:
138: --Bug 6594511 : Insert the corresponding item into acc table
139: SELECT cii.inventory_item_id,NVL(cii.LAST_VLD_ORGANIZATION_ID,cii.inv_master_organization_id)
140: INTO l_inv_item_id,l_lst_vld_org_id
141: FROM csi_item_instances cii
142: WHERE cii.instance_id = p_instance_id;
143:
144: csm_mtl_system_items_event_pkg.MTL_SYSTEM_ITEMS_ACC_I(l_inv_item_id,
145: l_lst_vld_org_id,

Line 262: FROM csi_item_instances cii

258: );
259: --Bug 6594511 :Delete the corresponding item from the acc table
260: SELECT cii.inventory_item_id,NVL(cii.LAST_VLD_ORGANIZATION_ID,cii.inv_master_organization_id)
261: INTO l_inv_item_id,l_lst_vld_org_id
262: FROM csi_item_instances cii
263: WHERE cii.instance_id = p_instance_id;
264:
265: csm_mtl_system_items_event_pkg.MTL_SYSTEM_ITEMS_ACC_D(l_inv_item_id,
266: l_lst_vld_org_id,

Line 309: , csi_item_instances cii

305: SELECT acc.access_id,
306: acc.user_ID
307: --acc.INSTANCE_ID
308: FROM csm_item_instances_acc acc
309: , csi_item_instances cii
310: , csi_instance_statuses iis
311: , asg_user asg
312: WHERE cii.instance_id = acc.instance_id
313: AND cii.location_type_code = 'INVENTORY'

Line 329: , csi_item_instances cii

325: SELECT acc.access_id,
326: acc.user_ID,
327: acc.INSTANCE_ID
328: FROM csm_item_instances_acc acc
329: , csi_item_instances cii
330: , asg_user asg
331: WHERE cii.instance_id = acc.instance_id
332: AND cii.location_type_code = 'INVENTORY'
333: AND asg.user_id = asg.owner_id

Line 358: csi_item_instances cii,

354: acc.user_id,
355: --acc.instance_id,
356: acc.access_id
357: FROM csm_item_instances_acc acc,
358: csi_item_instances cii,
359: asg_user asg
360: WHERE cii.instance_id = acc.instance_id
361: AND asg.user_id = asg.owner_id
362: AND asg.user_id = acc.user_id

Line 377: , csi_item_instances cii

373: cii.instance_id,
374: civ.version_label,
375: CIR.OBJECT_ID
376: FROM csm_mtl_onhand_qty_acc cqa
377: , csi_item_instances cii
378: , csi_instance_statuses iis
379: , asg_user asg
380: , csi_i_version_labels civ
381: , CSI_II_RELATIONSHIPS CIR

Line 846: l_parent_instance_id csi_item_instances.instance_id%TYPE;

842: l_sqlerrno VARCHAR2(20);
843: l_sqlerrmsg VARCHAR2(4000);
844: l_error_msg VARCHAR2(4000);
845: l_return_status VARCHAR2(2000);
846: l_parent_instance_id csi_item_instances.instance_id%TYPE;
847: l_max_ib_at_location NUMBER;
848:
849: CURSOR c_ib_parent_csr(p_instance_id IN number)
850: IS

Line 868: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii

864: p_instance_id NUMBER,
865: p_parent_instance_id NUMBER )
866: IS
867: SELECT acc.instance_id
868: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii
869: WHERE acc.instance_id = cii.instance_id
870: AND acc.user_id = p_user_id
871: AND owner_party_id = p_party_id
872: AND ( ( cii.location_id = p_party_site_id

Line 908: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS_B si

904: p_location_id NUMBER,
905: p_party_id NUMBER )
906: IS
907: SELECT cii.instance_id
908: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS_B si
909: WHERE si.inventory_item_id = cii.inventory_item_id
910: AND si.organization_id = NVL( cii.inv_organization_id,
911: cii.inv_master_organization_id )
912: AND cii.instance_id NOT IN

Line 1061: l_parent_instance_id csi_item_instances.instance_id%TYPE;

1057: l_sqlerrno VARCHAR2(20);
1058: l_sqlerrmsg VARCHAR2(4000);
1059: l_error_msg VARCHAR2(4000);
1060: l_return_status VARCHAR2(2000);
1061: l_parent_instance_id csi_item_instances.instance_id%TYPE;
1062:
1063: -- the below query prevents deletion of the configuration of the current IB item
1064: -- however it needs further validation to correctly delete IB at location.
1065: CURSOR c_ib_at_location_csr (

Line 1072: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii,

1068: p_location_id NUMBER,
1069: p_party_id NUMBER,
1070: p_incident_id NUMBER ) IS
1071: SELECT acc.instance_id
1072: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii,
1073: csm_incidents_all_acc iacc, cs_incidents_all_b cia
1074: WHERE acc.instance_id = cii.instance_id
1075: AND acc.user_id = p_user_id
1076: AND acc.counter <> 1 -- do not delete if there is just 1 instance of the IB item

Line 1096: CSI_ITEM_INSTANCES CII

1092: AND SYSDATE BETWEEN NVL(CIRo.active_start_date, SYSDATE)
1093: AND NVL(CIRo.active_end_date, SYSDATE)
1094: CONNECT BY CIRo.OBJECT_ID = PRIOR CIRo.SUBJECT_ID
1095: ) CIR,
1096: CSI_ITEM_INSTANCES CII
1097: WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID
1098: AND cii.instance_id = acc.instance_id
1099: AND SYSDATE BETWEEN NVL ( CII.ACTIVE_START_DATE , SYSDATE )
1100: AND NVL ( CII.ACTIVE_END_DATE , SYSDATE)

Line 1201: , csi_item_instances cii

1197: SELECT acc.access_id,
1198: acc.user_ID,
1199: acc.INSTANCE_ID
1200: FROM csm_item_instances_acc acc
1201: , csi_item_instances cii
1202: WHERE cii.instance_id = acc.instance_id
1203: AND cii.location_type_code = 'INVENTORY'
1204: AND cii.inventory_item_id = p_inv_item_id
1205: AND cii.inv_organization_id = p_org_id