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.INVUPD1B dependencies on DUAL

Line 90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;

86: msi_tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE;
87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;
89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;
91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;
92:
93: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
94:

Line 91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;

87: msi_secondary_uom_code mtl_system_items.secondary_uom_code%TYPE;
88: msi_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE;
89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;
91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;
92:
93: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
94:
95:

Line 154: msi.dual_uom_deviation_high,

150: msi.tracking_quantity_ind,
151: msi.secondary_uom_code,
152: msi.secondary_default_ind,
153: msi.ont_pricing_qty_source,
154: msi.dual_uom_deviation_high,
155: msi.dual_uom_deviation_low
156: INTO msi_primary_uom,
157: msi_eng_item_flag,
158: msi_primary_uom_code, --* Added for Bug 4366615

Line 155: msi.dual_uom_deviation_low

151: msi.secondary_uom_code,
152: msi.secondary_default_ind,
153: msi.ont_pricing_qty_source,
154: msi.dual_uom_deviation_high,
155: msi.dual_uom_deviation_low
156: INTO msi_primary_uom,
157: msi_eng_item_flag,
158: msi_primary_uom_code, --* Added for Bug 4366615
159: msi_inventory_item_status_code,

Line 164: msi_dual_uom_deviation_high,

160: msi_tracking_quantity_ind,
161: msi_secondary_uom_code,
162: msi_secondary_default_ind,
163: msi_ont_pricing_qty_source,
164: msi_dual_uom_deviation_high,
165: msi_dual_uom_deviation_low
166: FROM mtl_system_items_B msi
167: WHERE msi.inventory_item_id = t_inventory_item_id
168: AND msi.organization_id = t_organization_id;

Line 165: msi_dual_uom_deviation_low

161: msi_secondary_uom_code,
162: msi_secondary_default_ind,
163: msi_ont_pricing_qty_source,
164: msi_dual_uom_deviation_high,
165: msi_dual_uom_deviation_low
166: FROM mtl_system_items_B msi
167: WHERE msi.inventory_item_id = t_inventory_item_id
168: AND msi.organization_id = t_organization_id;
169: EXCEPTION

Line 185: Decode (rec.dual_uom_deviation_high,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_high),

181: Decode (rec.tracking_quantity_ind,g_Upd_Null_CHAR,NULL,rec.tracking_quantity_ind),
182: Decode (rec.secondary_uom_code,g_Upd_Null_CHAR,NULL,rec.secondary_uom_code),
183: Decode (rec.secondary_default_ind,g_Upd_Null_CHAR,NULL,rec.secondary_default_ind),
184: Decode (rec.ont_pricing_qty_source,g_Upd_Null_CHAR,NULL,rec.ont_pricing_qty_source),
185: Decode (rec.dual_uom_deviation_high,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_high),
186: Decode (rec.dual_uom_deviation_low,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_low)
187: INTO rec.ENG_ITEM_FLAG,rec.PRIMARY_UOM_CODE,rec.tracking_quantity_ind, rec.secondary_uom_code,rec.secondary_default_ind,
188: rec.ont_pricing_qty_source, rec.dual_uom_deviation_high, rec.dual_uom_deviation_low
189: FROM dual;

Line 186: Decode (rec.dual_uom_deviation_low,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_low)

182: Decode (rec.secondary_uom_code,g_Upd_Null_CHAR,NULL,rec.secondary_uom_code),
183: Decode (rec.secondary_default_ind,g_Upd_Null_CHAR,NULL,rec.secondary_default_ind),
184: Decode (rec.ont_pricing_qty_source,g_Upd_Null_CHAR,NULL,rec.ont_pricing_qty_source),
185: Decode (rec.dual_uom_deviation_high,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_high),
186: Decode (rec.dual_uom_deviation_low,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_low)
187: INTO rec.ENG_ITEM_FLAG,rec.PRIMARY_UOM_CODE,rec.tracking_quantity_ind, rec.secondary_uom_code,rec.secondary_default_ind,
188: rec.ont_pricing_qty_source, rec.dual_uom_deviation_high, rec.dual_uom_deviation_low
189: FROM dual;
190:

Line 188: rec.ont_pricing_qty_source, rec.dual_uom_deviation_high, rec.dual_uom_deviation_low

184: Decode (rec.ont_pricing_qty_source,g_Upd_Null_CHAR,NULL,rec.ont_pricing_qty_source),
185: Decode (rec.dual_uom_deviation_high,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_high),
186: Decode (rec.dual_uom_deviation_low,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_low)
187: INTO rec.ENG_ITEM_FLAG,rec.PRIMARY_UOM_CODE,rec.tracking_quantity_ind, rec.secondary_uom_code,rec.secondary_default_ind,
188: rec.ont_pricing_qty_source, rec.dual_uom_deviation_high, rec.dual_uom_deviation_low
189: FROM dual;
190:
191: -- if any of the non-updateable fields are being updated [ENG_ITEM_FLAG and PRIMARY_UOM]
192: IF (rec.MATERIAL_COST IS NULL

Line 189: FROM dual;

185: Decode (rec.dual_uom_deviation_high,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_high),
186: Decode (rec.dual_uom_deviation_low,g_Upd_Null_CHAR,NULL,rec.dual_uom_deviation_low)
187: INTO rec.ENG_ITEM_FLAG,rec.PRIMARY_UOM_CODE,rec.tracking_quantity_ind, rec.secondary_uom_code,rec.secondary_default_ind,
188: rec.ont_pricing_qty_source, rec.dual_uom_deviation_high, rec.dual_uom_deviation_low
189: FROM dual;
190:
191: -- if any of the non-updateable fields are being updated [ENG_ITEM_FLAG and PRIMARY_UOM]
192: IF (rec.MATERIAL_COST IS NULL
193: AND rec.MATERIAL_SUB_ELEM IS NULL

Line 208: AND (rec.dual_uom_deviation_high IS NULL OR rec.dual_uom_deviation_high = msi_dual_uom_deviation_high )

204: AND (rec.tracking_quantity_ind IS NULL OR rec.tracking_quantity_ind = msi_tracking_quantity_ind )
205: AND (rec.secondary_uom_code IS NULL OR rec.secondary_uom_code = msi_secondary_uom_code )
206: AND (rec.secondary_default_ind IS NULL OR rec.secondary_default_ind = msi_secondary_default_ind )
207: AND (rec.ont_pricing_qty_source IS NULL OR rec.ont_pricing_qty_source = msi_ont_pricing_qty_source )
208: AND (rec.dual_uom_deviation_high IS NULL OR rec.dual_uom_deviation_high = msi_dual_uom_deviation_high )
209: AND (rec.dual_uom_deviation_low IS NULL OR rec.dual_uom_deviation_low = msi_dual_uom_deviation_low )
210: THEN
211:
212: status_code := 1;

Line 209: AND (rec.dual_uom_deviation_low IS NULL OR rec.dual_uom_deviation_low = msi_dual_uom_deviation_low )

205: AND (rec.secondary_uom_code IS NULL OR rec.secondary_uom_code = msi_secondary_uom_code )
206: AND (rec.secondary_default_ind IS NULL OR rec.secondary_default_ind = msi_secondary_default_ind )
207: AND (rec.ont_pricing_qty_source IS NULL OR rec.ont_pricing_qty_source = msi_ont_pricing_qty_source )
208: AND (rec.dual_uom_deviation_high IS NULL OR rec.dual_uom_deviation_high = msi_dual_uom_deviation_high )
209: AND (rec.dual_uom_deviation_low IS NULL OR rec.dual_uom_deviation_low = msi_dual_uom_deviation_low )
210: THEN
211:
212: status_code := 1;
213: /* Bug 4751471 Status Controlled attrs are relevantly updated when status is applied. Eliminating this chk

Line 477: DUAL_UOM_DEVIATION_HIGH,

473: /* Start Bug 3713912 */
474: SECONDARY_UOM_CODE ,
475: TRACKING_QUANTITY_IND,
476: SECONDARY_DEFAULT_IND,
477: DUAL_UOM_DEVIATION_HIGH,
478: DUAL_UOM_DEVIATION_LOW
479: /* End Bug 3713912 */
480: from MTL_SYSTEM_ITEMS_INTERFACE
481: where rowid = row_id;

Line 478: DUAL_UOM_DEVIATION_LOW

474: SECONDARY_UOM_CODE ,
475: TRACKING_QUANTITY_IND,
476: SECONDARY_DEFAULT_IND,
477: DUAL_UOM_DEVIATION_HIGH,
478: DUAL_UOM_DEVIATION_LOW
479: /* End Bug 3713912 */
480: from MTL_SYSTEM_ITEMS_INTERFACE
481: where rowid = row_id;
482:

Line 498: DUAL_UOM_DEVIATION_HIGH,

494: /* Start Bug 3713912 */
495: SECONDARY_UOM_CODE ,
496: TRACKING_QUANTITY_IND,
497: SECONDARY_DEFAULT_IND,
498: DUAL_UOM_DEVIATION_HIGH,
499: DUAL_UOM_DEVIATION_LOW
500: /* End Bug 3713912 */
501: from MTL_SYSTEM_ITEMS
502: where inventory_item_id = item_id

Line 499: DUAL_UOM_DEVIATION_LOW

495: SECONDARY_UOM_CODE ,
496: TRACKING_QUANTITY_IND,
497: SECONDARY_DEFAULT_IND,
498: DUAL_UOM_DEVIATION_HIGH,
499: DUAL_UOM_DEVIATION_LOW
500: /* End Bug 3713912 */
501: from MTL_SYSTEM_ITEMS
502: where inventory_item_id = item_id
503: and organization_id = org_id;

Line 713: -- Dual UOM Deviation High

709: end if;
710: end if; --}
711: -- Secondary UOM Code
712:
713: -- Dual UOM Deviation High
714: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{
715: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then
716: attr_noerr_flg := 0;
717: else

Line 714: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{

710: end if; --}
711: -- Secondary UOM Code
712:
713: -- Dual UOM Deviation High
714: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{
715: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then
716: attr_noerr_flg := 0;
717: else
718: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';

Line 715: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then

711: -- Secondary UOM Code
712:
713: -- Dual UOM Deviation High
714: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{
715: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then
716: attr_noerr_flg := 0;
717: else
718: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';
719: raise attrib_error;

Line 718: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';

714: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{
715: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then
716: attr_noerr_flg := 0;
717: else
718: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';
719: raise attrib_error;
720: end if;
721: end if; --}
722: -- Dual UOM Deviation High

Line 722: -- Dual UOM Deviation High

718: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';
719: raise attrib_error;
720: end if;
721: end if; --}
722: -- Dual UOM Deviation High
723:
724: -- Dual UOM Deviation Low
725: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
726: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then

Line 724: -- Dual UOM Deviation Low

720: end if;
721: end if; --}
722: -- Dual UOM Deviation High
723:
724: -- Dual UOM Deviation Low
725: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
726: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then
727: attr_noerr_flg := 0;
728: else

Line 725: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{

721: end if; --}
722: -- Dual UOM Deviation High
723:
724: -- Dual UOM Deviation Low
725: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
726: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then
727: attr_noerr_flg := 0;
728: else
729: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';

Line 726: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then

722: -- Dual UOM Deviation High
723:
724: -- Dual UOM Deviation Low
725: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
726: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then
727: attr_noerr_flg := 0;
728: else
729: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';
730: raise attrib_error;

Line 729: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';

725: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
726: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then
727: attr_noerr_flg := 0;
728: else
729: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';
730: raise attrib_error;
731: end if;
732: end if; --}
733: -- Dual UOM Deviation Low

Line 733: -- Dual UOM Deviation Low

729: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';
730: raise attrib_error;
731: end if;
732: end if; --}
733: -- Dual UOM Deviation Low
734: /* End Bug 3713912 */
735: return attr_noerr_flg;
736: close msi_attr;
737: close msii_attr;

Line 3635: IF msii_temp_data.DUAL_UOM_CONTROL is null then

3631: msii_temp_data.EAM_ACT_NOTIFICATION_FLAG := NULL;
3632: ELSE
3633: msii_temp_data.EAM_ACT_NOTIFICATION_FLAG := trim(msii_temp_data.EAM_ACT_NOTIFICATION_FLAG);
3634: END IF;
3635: IF msii_temp_data.DUAL_UOM_CONTROL is null then
3636: msii_temp_data.DUAL_UOM_CONTROL := msi_record_temp.DUAL_UOM_CONTROL;
3637: END IF;
3638:
3639: msii_temp_data.SECONDARY_UOM_CODE := trim(msi_record_temp.SECONDARY_UOM_CODE);

Line 3636: msii_temp_data.DUAL_UOM_CONTROL := msi_record_temp.DUAL_UOM_CONTROL;

3632: ELSE
3633: msii_temp_data.EAM_ACT_NOTIFICATION_FLAG := trim(msii_temp_data.EAM_ACT_NOTIFICATION_FLAG);
3634: END IF;
3635: IF msii_temp_data.DUAL_UOM_CONTROL is null then
3636: msii_temp_data.DUAL_UOM_CONTROL := msi_record_temp.DUAL_UOM_CONTROL;
3637: END IF;
3638:
3639: msii_temp_data.SECONDARY_UOM_CODE := trim(msi_record_temp.SECONDARY_UOM_CODE);
3640: msii_temp_data.DUAL_UOM_DEVIATION_HIGH := msi_record_temp.DUAL_UOM_DEVIATION_HIGH;

Line 3640: msii_temp_data.DUAL_UOM_DEVIATION_HIGH := msi_record_temp.DUAL_UOM_DEVIATION_HIGH;

3636: msii_temp_data.DUAL_UOM_CONTROL := msi_record_temp.DUAL_UOM_CONTROL;
3637: END IF;
3638:
3639: msii_temp_data.SECONDARY_UOM_CODE := trim(msi_record_temp.SECONDARY_UOM_CODE);
3640: msii_temp_data.DUAL_UOM_DEVIATION_HIGH := msi_record_temp.DUAL_UOM_DEVIATION_HIGH;
3641: msii_temp_data.DUAL_UOM_DEVIATION_LOW := msi_record_temp.DUAL_UOM_DEVIATION_LOW;
3642:
3643: IF msii_temp_data.SUBSCRIPTION_DEPEND_FLAG IS NULL THEN
3644: msii_temp_data.SUBSCRIPTION_DEPEND_FLAG := msi_record_temp.SUBSCRIPTION_DEPEND_FLAG;

Line 3641: msii_temp_data.DUAL_UOM_DEVIATION_LOW := msi_record_temp.DUAL_UOM_DEVIATION_LOW;

3637: END IF;
3638:
3639: msii_temp_data.SECONDARY_UOM_CODE := trim(msi_record_temp.SECONDARY_UOM_CODE);
3640: msii_temp_data.DUAL_UOM_DEVIATION_HIGH := msi_record_temp.DUAL_UOM_DEVIATION_HIGH;
3641: msii_temp_data.DUAL_UOM_DEVIATION_LOW := msi_record_temp.DUAL_UOM_DEVIATION_LOW;
3642:
3643: IF msii_temp_data.SUBSCRIPTION_DEPEND_FLAG IS NULL THEN
3644: msii_temp_data.SUBSCRIPTION_DEPEND_FLAG := msi_record_temp.SUBSCRIPTION_DEPEND_FLAG;
3645: ELSIF msii_temp_data.SUBSCRIPTION_DEPEND_FLAG = g_Upd_Null_CHAR THEN

Line 4299: FROM dual;

4295: RETURNING transaction_id INTO tran_id;
4296: /*
4297: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4298: INTO tran_id
4299: FROM dual;
4300: */
4301: dumm_status := INVPUOPI.mtl_log_interface_err(
4302: cr.organization_id,
4303: user_id,

Line 4347: INTO tran_id FROM dual;

4343: --Assign Transaction Id
4344: FOR cr IN c_fill_transaction_id LOOP
4345:
4346: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4347: INTO tran_id FROM dual;
4348:
4349: UPDATE mtl_item_revisions_interface
4350: SET transaction_id = tran_id
4351: WHERE inventory_item_id = cr.inventory_item_id