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 142: FROM csi_item_instances cii

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

Line 263: FROM csi_item_instances cii

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

Line 310: , csi_item_instances cii

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

Line 330: , csi_item_instances cii

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

Line 359: csi_item_instances cii,

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

Line 376: , csi_item_instances cii

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

Line 789: l_parent_instance_id csi_item_instances.instance_id%TYPE;

785: l_sqlerrno VARCHAR2(20);
786: l_sqlerrmsg VARCHAR2(4000);
787: l_error_msg VARCHAR2(4000);
788: l_return_status VARCHAR2(2000);
789: l_parent_instance_id csi_item_instances.instance_id%TYPE;
790: l_max_ib_at_location NUMBER;
791:
792: CURSOR c_ib_parent_csr(p_instance_id IN number)
793: IS

Line 812: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii

808: p_parent_instance_id NUMBER )
809: IS
810: SELECT acc.instance_id,cii.inventory_item_id inv_item_id ,
811: NVL(cii.LAST_VLD_ORGANIZATION_ID,cii.inv_master_organization_id) org_id
812: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii
813: WHERE acc.instance_id = cii.instance_id
814: AND acc.user_id = p_user_id
815: AND owner_party_id = p_party_id
816: AND ( ( cii.location_id = p_party_site_id

Line 853: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS_B si

849: p_party_id NUMBER )
850: IS
851: SELECT cii.instance_id,cii.inventory_item_id inv_item_id,
852: NVL(cii.LAST_VLD_ORGANIZATION_ID,cii.inv_master_organization_id) org_id
853: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS_B si
854: WHERE si.inventory_item_id = cii.inventory_item_id
855: AND si.organization_id = NVL( cii.LAST_VLD_ORGANIZATION_ID,
856: cii.inv_master_organization_id )
857: AND cii.instance_id NOT IN

Line 1020: l_parent_instance_id csi_item_instances.instance_id%TYPE;

1016: l_sqlerrno VARCHAR2(20);
1017: l_sqlerrmsg VARCHAR2(4000);
1018: l_error_msg VARCHAR2(4000);
1019: l_return_status VARCHAR2(2000);
1020: l_parent_instance_id csi_item_instances.instance_id%TYPE;
1021:
1022: -- the below query prevents deletion of the configuration of the current IB item
1023: -- however it needs further validation to correctly delete IB at location.
1024: CURSOR c_ib_at_location_csr (

Line 1031: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii,

1027: p_location_id NUMBER,
1028: p_party_id NUMBER,
1029: p_incident_id NUMBER ) IS
1030: SELECT acc.instance_id
1031: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii,
1032: csm_incidents_all_acc iacc, cs_incidents_all_b cia
1033: WHERE acc.instance_id = cii.instance_id
1034: AND acc.user_id = p_user_id
1035: AND acc.counter <> 1 -- do not delete if there is just 1 instance of the IB item

Line 1055: CSI_ITEM_INSTANCES CII

1051: AND SYSDATE BETWEEN NVL(CIRo.active_start_date, SYSDATE)
1052: AND NVL(CIRo.active_end_date, SYSDATE)
1053: CONNECT BY CIRo.OBJECT_ID = PRIOR CIRo.SUBJECT_ID
1054: ) CIR,
1055: CSI_ITEM_INSTANCES CII
1056: WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID
1057: AND cii.instance_id = acc.instance_id
1058: AND SYSDATE BETWEEN NVL ( CII.ACTIVE_START_DATE , SYSDATE )
1059: AND NVL ( CII.ACTIVE_END_DATE , SYSDATE)

Line 1154: , csi_item_instances cii

1150: SELECT acc.access_id,
1151: acc.user_ID,
1152: acc.INSTANCE_ID
1153: FROM csm_item_instances_acc acc
1154: , csi_item_instances cii
1155: WHERE cii.instance_id = acc.instance_id
1156: AND cii.location_type_code = 'INVENTORY'
1157: AND cii.inventory_item_id = p_inv_item_id
1158: AND cii.inv_organization_id = p_org_id