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.CSD_MIGRATE_FROM_115X_PKG3 dependencies on CSI_ITEM_INSTANCES

Line 3647: -- If Item is IB Trackable Then get IB Ref Number from csi_item_instances

3643: v_Source_Serial_Number(j) := Null;
3644: End;
3645: End;
3646:
3647: -- If Item is IB Trackable Then get IB Ref Number from csi_item_instances
3648: -- To fix bug 3842957/4140451 saupadhy
3649: -- Added check for not null value for source_Serial_Number
3650: If v_comms_Nls_trackable_flag(j) = 'Y'
3651: and v_Source_Serial_Number(j) is Not Null Then

Line 3656: from csi_item_instances

3652: Begin
3653: l_procedure_Event := 'IB info for serial and received item';
3654: select instance_id
3655: Into v_Source_Instance_Id(j)
3656: from csi_item_instances
3657: where inventory_item_id = v_inventory_item_id(j)
3658: and serial_number = v_Source_Serial_Number(j) ;
3659: -- Following statement is incorrect and not required so commenting it.
3660: -- and inv_master_organization_id = cs_std.get_item_valdn_orgzn_id;

Line 3742: from csi_item_instances

3738: Following code is not required as item is non serialized
3739: Begin
3740: select Serial_Number
3741: Into v_Non_Source_Serial_Number(j)
3742: from csi_item_instances
3743: where inventory_item_id = v_inventory_item_id(j)
3744: and instance_id = v_Customer_Product_Id(j)
3745: and inv_master_organization_Id = cs_std.get_item_valdn_orgzn_id;
3746:

Line 3782: -- If Item is IB Trackable Then get Corresponding IB Ref Number from csi_item_instances

3778: and wdt.source_line_id = v_order_line_id(j)
3779: and wdt.delivery_detail_id = wsn.delivery_detail_id(+)
3780: and rownum = 1;
3781:
3782: -- If Item is IB Trackable Then get Corresponding IB Ref Number from csi_item_instances
3783: If v_comms_Nls_trackable_flag(j) = 'Y' Then
3784: Begin
3785: l_procedure_Event := 'Getting IB info for a serial item-Ship line';
3786: select instance_id

Line 3788: from csi_item_instances

3784: Begin
3785: l_procedure_Event := 'Getting IB info for a serial item-Ship line';
3786: select instance_id
3787: Into v_Source_Instance_Id(j)
3788: from csi_item_instances
3789: where inventory_item_id = v_inventory_item_id(j)
3790: and serial_number = v_Source_Serial_Number(j) ;
3791: Exception
3792: When No_Data_Found Then

Line 3801: from csi_item_instances

3797: if v_repair_type_ref(j) in ('AE','E','R') Then
3798: Begin
3799: select Serial_Number
3800: Into v_Non_Source_Serial_Number(j)
3801: from csi_item_instances
3802: where inventory_item_id = v_inventory_item_id(j)
3803: and instance_id = v_Customer_Product_Id(j);
3804: -- and inv_master_organization_Id = cs_std.get_item_valdn_orgzn_id;
3805: -- Commented above line 3742767