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 192: AND (rec.dual_uom_deviation_high IS NULL OR rec.dual_uom_deviation_high = msi_dual_uom_deviation_high )

188: AND (rec.tracking_quantity_ind IS NULL OR rec.tracking_quantity_ind = msi_tracking_quantity_ind )
189: AND (rec.secondary_uom_code IS NULL OR rec.secondary_uom_code = msi_secondary_uom_code )
190: AND (rec.secondary_default_ind IS NULL OR rec.secondary_default_ind = msi_secondary_default_ind )
191: AND (rec.ont_pricing_qty_source IS NULL OR rec.ont_pricing_qty_source = msi_ont_pricing_qty_source )
192: AND (rec.dual_uom_deviation_high IS NULL OR rec.dual_uom_deviation_high = msi_dual_uom_deviation_high )
193: AND (rec.dual_uom_deviation_low IS NULL OR rec.dual_uom_deviation_low = msi_dual_uom_deviation_low )
194: THEN
195:
196: status_code := 1;

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

189: AND (rec.secondary_uom_code IS NULL OR rec.secondary_uom_code = msi_secondary_uom_code )
190: AND (rec.secondary_default_ind IS NULL OR rec.secondary_default_ind = msi_secondary_default_ind )
191: AND (rec.ont_pricing_qty_source IS NULL OR rec.ont_pricing_qty_source = msi_ont_pricing_qty_source )
192: AND (rec.dual_uom_deviation_high IS NULL OR rec.dual_uom_deviation_high = msi_dual_uom_deviation_high )
193: AND (rec.dual_uom_deviation_low IS NULL OR rec.dual_uom_deviation_low = msi_dual_uom_deviation_low )
194: THEN
195:
196: status_code := 1;
197: /* Bug 4751471 Status Controlled attrs are relevantly updated when status is applied. Eliminating this chk

Line 461: DUAL_UOM_DEVIATION_HIGH,

457: /* Start Bug 3713912 */
458: SECONDARY_UOM_CODE ,
459: TRACKING_QUANTITY_IND,
460: SECONDARY_DEFAULT_IND,
461: DUAL_UOM_DEVIATION_HIGH,
462: DUAL_UOM_DEVIATION_LOW
463: /* End Bug 3713912 */
464: from MTL_SYSTEM_ITEMS_INTERFACE
465: where rowid = row_id;

Line 462: DUAL_UOM_DEVIATION_LOW

458: SECONDARY_UOM_CODE ,
459: TRACKING_QUANTITY_IND,
460: SECONDARY_DEFAULT_IND,
461: DUAL_UOM_DEVIATION_HIGH,
462: DUAL_UOM_DEVIATION_LOW
463: /* End Bug 3713912 */
464: from MTL_SYSTEM_ITEMS_INTERFACE
465: where rowid = row_id;
466:

Line 482: DUAL_UOM_DEVIATION_HIGH,

478: /* Start Bug 3713912 */
479: SECONDARY_UOM_CODE ,
480: TRACKING_QUANTITY_IND,
481: SECONDARY_DEFAULT_IND,
482: DUAL_UOM_DEVIATION_HIGH,
483: DUAL_UOM_DEVIATION_LOW
484: /* End Bug 3713912 */
485: from MTL_SYSTEM_ITEMS
486: where inventory_item_id = item_id

Line 483: DUAL_UOM_DEVIATION_LOW

479: SECONDARY_UOM_CODE ,
480: TRACKING_QUANTITY_IND,
481: SECONDARY_DEFAULT_IND,
482: DUAL_UOM_DEVIATION_HIGH,
483: DUAL_UOM_DEVIATION_LOW
484: /* End Bug 3713912 */
485: from MTL_SYSTEM_ITEMS
486: where inventory_item_id = item_id
487: and organization_id = org_id;

Line 697: -- Dual UOM Deviation High

693: end if;
694: end if; --}
695: -- Secondary UOM Code
696:
697: -- Dual UOM Deviation High
698: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{
699: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then
700: attr_noerr_flg := 0;
701: else

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

694: end if; --}
695: -- Secondary UOM Code
696:
697: -- Dual UOM Deviation High
698: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{
699: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then
700: attr_noerr_flg := 0;
701: else
702: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';

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

695: -- Secondary UOM Code
696:
697: -- Dual UOM Deviation High
698: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{
699: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then
700: attr_noerr_flg := 0;
701: else
702: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';
703: raise attrib_error;

Line 702: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';

698: if msii_rec.DUAL_UOM_DEVIATION_HIGH is not null then --{
699: if msi_rec.DUAL_UOM_DEVIATION_HIGH = msii_rec.DUAL_UOM_DEVIATION_HIGH then
700: attr_noerr_flg := 0;
701: else
702: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';
703: raise attrib_error;
704: end if;
705: end if; --}
706: -- Dual UOM Deviation High

Line 706: -- Dual UOM Deviation High

702: attr_err_mesg_name := 'INV_IOI_DUAL_HI_DEV_UPD_QOH';
703: raise attrib_error;
704: end if;
705: end if; --}
706: -- Dual UOM Deviation High
707:
708: -- Dual UOM Deviation Low
709: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
710: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then

Line 708: -- Dual UOM Deviation Low

704: end if;
705: end if; --}
706: -- Dual UOM Deviation High
707:
708: -- Dual UOM Deviation Low
709: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
710: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then
711: attr_noerr_flg := 0;
712: else

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

705: end if; --}
706: -- Dual UOM Deviation High
707:
708: -- Dual UOM Deviation Low
709: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
710: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then
711: attr_noerr_flg := 0;
712: else
713: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';

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

706: -- Dual UOM Deviation High
707:
708: -- Dual UOM Deviation Low
709: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
710: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then
711: attr_noerr_flg := 0;
712: else
713: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';
714: raise attrib_error;

Line 713: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';

709: if msii_rec.DUAL_UOM_DEVIATION_LOW is not null then --{
710: if msi_rec.DUAL_UOM_DEVIATION_LOW = msii_rec.DUAL_UOM_DEVIATION_LOW then
711: attr_noerr_flg := 0;
712: else
713: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';
714: raise attrib_error;
715: end if;
716: end if; --}
717: -- Dual UOM Deviation Low

Line 717: -- Dual UOM Deviation Low

713: attr_err_mesg_name := 'INV_IOI_DUAL_LOW_DEV_UPD_QOH';
714: raise attrib_error;
715: end if;
716: end if; --}
717: -- Dual UOM Deviation Low
718: /* End Bug 3713912 */
719: return attr_noerr_flg;
720: close msi_attr;
721: close msii_attr;

Line 3608: IF msii_temp_data.DUAL_UOM_CONTROL is null then

3604: msii_temp_data.EAM_ACT_NOTIFICATION_FLAG := NULL;
3605: ELSE
3606: msii_temp_data.EAM_ACT_NOTIFICATION_FLAG := trim(msii_temp_data.EAM_ACT_NOTIFICATION_FLAG);
3607: END IF;
3608: IF msii_temp_data.DUAL_UOM_CONTROL is null then
3609: msii_temp_data.DUAL_UOM_CONTROL := msi_record_temp.DUAL_UOM_CONTROL;
3610: END IF;
3611:
3612: msii_temp_data.SECONDARY_UOM_CODE := trim(msi_record_temp.SECONDARY_UOM_CODE);

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

3605: ELSE
3606: msii_temp_data.EAM_ACT_NOTIFICATION_FLAG := trim(msii_temp_data.EAM_ACT_NOTIFICATION_FLAG);
3607: END IF;
3608: IF msii_temp_data.DUAL_UOM_CONTROL is null then
3609: msii_temp_data.DUAL_UOM_CONTROL := msi_record_temp.DUAL_UOM_CONTROL;
3610: END IF;
3611:
3612: msii_temp_data.SECONDARY_UOM_CODE := trim(msi_record_temp.SECONDARY_UOM_CODE);
3613: msii_temp_data.DUAL_UOM_DEVIATION_HIGH := msi_record_temp.DUAL_UOM_DEVIATION_HIGH;

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

3609: msii_temp_data.DUAL_UOM_CONTROL := msi_record_temp.DUAL_UOM_CONTROL;
3610: END IF;
3611:
3612: msii_temp_data.SECONDARY_UOM_CODE := trim(msi_record_temp.SECONDARY_UOM_CODE);
3613: msii_temp_data.DUAL_UOM_DEVIATION_HIGH := msi_record_temp.DUAL_UOM_DEVIATION_HIGH;
3614: msii_temp_data.DUAL_UOM_DEVIATION_LOW := msi_record_temp.DUAL_UOM_DEVIATION_LOW;
3615:
3616: IF msii_temp_data.SUBSCRIPTION_DEPEND_FLAG IS NULL THEN
3617: msii_temp_data.SUBSCRIPTION_DEPEND_FLAG := msi_record_temp.SUBSCRIPTION_DEPEND_FLAG;

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

3610: END IF;
3611:
3612: msii_temp_data.SECONDARY_UOM_CODE := trim(msi_record_temp.SECONDARY_UOM_CODE);
3613: msii_temp_data.DUAL_UOM_DEVIATION_HIGH := msi_record_temp.DUAL_UOM_DEVIATION_HIGH;
3614: msii_temp_data.DUAL_UOM_DEVIATION_LOW := msi_record_temp.DUAL_UOM_DEVIATION_LOW;
3615:
3616: IF msii_temp_data.SUBSCRIPTION_DEPEND_FLAG IS NULL THEN
3617: msii_temp_data.SUBSCRIPTION_DEPEND_FLAG := msi_record_temp.SUBSCRIPTION_DEPEND_FLAG;
3618: ELSIF msii_temp_data.SUBSCRIPTION_DEPEND_FLAG = g_Upd_Null_CHAR THEN

Line 4272: FROM dual;

4268: RETURNING transaction_id INTO tran_id;
4269: /*
4270: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4271: INTO tran_id
4272: FROM dual;
4273: */
4274: dumm_status := INVPUOPI.mtl_log_interface_err(
4275: cr.organization_id,
4276: user_id,

Line 4320: INTO tran_id FROM dual;

4316: --Assign Transaction Id
4317: FOR cr IN c_fill_transaction_id LOOP
4318:
4319: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4320: INTO tran_id FROM dual;
4321:
4322: UPDATE mtl_item_revisions_interface
4323: SET transaction_id = tran_id
4324: WHERE inventory_item_id = cr.inventory_item_id