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

Line 277: , MSI.DUAL_UOM_CONTROL

273: , MSI.EAM_ACTIVITY_TYPE_CODE
274: , MSI.EAM_ACTIVITY_CAUSE_CODE
275: , MSI.EAM_ACT_NOTIFICATION_FLAG
276: , MSI.EAM_ACT_SHUTDOWN_STATUS
277: , MSI.DUAL_UOM_CONTROL
278: , MSI.SECONDARY_UOM_CODE
279: , MSI.DUAL_UOM_DEVIATION_HIGH
280: , MSI.DUAL_UOM_DEVIATION_LOW
281: --

Line 279: , MSI.DUAL_UOM_DEVIATION_HIGH

275: , MSI.EAM_ACT_NOTIFICATION_FLAG
276: , MSI.EAM_ACT_SHUTDOWN_STATUS
277: , MSI.DUAL_UOM_CONTROL
278: , MSI.SECONDARY_UOM_CODE
279: , MSI.DUAL_UOM_DEVIATION_HIGH
280: , MSI.DUAL_UOM_DEVIATION_LOW
281: --
282: , MSI.SERVICE_ITEM_FLAG
283: , MSI.VENDOR_WARRANTY_FLAG

Line 280: , MSI.DUAL_UOM_DEVIATION_LOW

276: , MSI.EAM_ACT_SHUTDOWN_STATUS
277: , MSI.DUAL_UOM_CONTROL
278: , MSI.SECONDARY_UOM_CODE
279: , MSI.DUAL_UOM_DEVIATION_HIGH
280: , MSI.DUAL_UOM_DEVIATION_LOW
281: --
282: , MSI.SERVICE_ITEM_FLAG
283: , MSI.VENDOR_WARRANTY_FLAG
284: , MSI.USAGE_ITEM_FLAG

Line 1794: FROM dual;

1790: -- Get unique process set id for one record processing.
1791:
1792: SELECT mtl_system_items_intf_sets_s.NEXTVAL
1793: INTO l_set_process_id
1794: FROM dual;
1795:
1796: x_set_process_id := l_set_process_id;
1797:
1798: --5565453 : Appsperf issues reducing the shared memory.

Line 3239: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN

3235: ELSIF p_Item_rec.EAM_ACT_SHUTDOWN_STATUS = g_MISS_CHAR THEN
3236: l_Item_rec.EAM_ACT_SHUTDOWN_STATUS := null;
3237: END IF;
3238:
3239: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN
3240: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;
3241: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN
3242: l_Item_rec.DUAL_UOM_CONTROL := null;
3243: END IF;

Line 3240: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;

3236: l_Item_rec.EAM_ACT_SHUTDOWN_STATUS := null;
3237: END IF;
3238:
3239: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN
3240: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;
3241: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN
3242: l_Item_rec.DUAL_UOM_CONTROL := null;
3243: END IF;
3244:

Line 3241: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN

3237: END IF;
3238:
3239: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN
3240: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;
3241: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN
3242: l_Item_rec.DUAL_UOM_CONTROL := null;
3243: END IF;
3244:
3245: IF(p_Item_rec.SECONDARY_UOM_CODE IS NULL) THEN

Line 3242: l_Item_rec.DUAL_UOM_CONTROL := null;

3238:
3239: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN
3240: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;
3241: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN
3242: l_Item_rec.DUAL_UOM_CONTROL := null;
3243: END IF;
3244:
3245: IF(p_Item_rec.SECONDARY_UOM_CODE IS NULL) THEN
3246: l_Item_rec.SECONDARY_UOM_CODE := g_Upd_Null_CHAR;

Line 3251: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN

3247: ELSIF p_Item_rec.SECONDARY_UOM_CODE = g_MISS_CHAR THEN
3248: l_Item_rec.SECONDARY_UOM_CODE := null;
3249: END IF;
3250:
3251: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN
3252: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;
3253: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
3254: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
3255: END IF;

Line 3252: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;

3248: l_Item_rec.SECONDARY_UOM_CODE := null;
3249: END IF;
3250:
3251: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN
3252: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;
3253: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
3254: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
3255: END IF;
3256:

Line 3253: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN

3249: END IF;
3250:
3251: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN
3252: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;
3253: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
3254: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
3255: END IF;
3256:
3257: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN

Line 3254: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;

3250:
3251: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN
3252: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;
3253: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
3254: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
3255: END IF;
3256:
3257: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
3258: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;

Line 3257: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN

3253: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
3254: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
3255: END IF;
3256:
3257: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
3258: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;
3259: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN
3260: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;
3261: END IF;

Line 3258: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;

3254: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
3255: END IF;
3256:
3257: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
3258: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;
3259: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN
3260: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;
3261: END IF;
3262:

Line 3259: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN

3255: END IF;
3256:
3257: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
3258: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;
3259: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN
3260: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;
3261: END IF;
3262:
3263: IF(p_Item_rec.SUBSCRIPTION_DEPEND_FLAG IS NULL) THEN

Line 3260: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;

3256:
3257: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
3258: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;
3259: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN
3260: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;
3261: END IF;
3262:
3263: IF(p_Item_rec.SUBSCRIPTION_DEPEND_FLAG IS NULL) THEN
3264: l_Item_rec.SUBSCRIPTION_DEPEND_FLAG := g_Upd_Null_CHAR;

Line 4288: ,DUAL_UOM_CONTROL

4284: ,EAM_ACTIVITY_TYPE_CODE
4285: ,EAM_ACTIVITY_CAUSE_CODE
4286: ,EAM_ACT_NOTIFICATION_FLAG
4287: ,EAM_ACT_SHUTDOWN_STATUS
4288: ,DUAL_UOM_CONTROL
4289: ,SECONDARY_UOM_CODE
4290: ,DUAL_UOM_DEVIATION_HIGH
4291: ,DUAL_UOM_DEVIATION_LOW
4292: --

Line 4290: ,DUAL_UOM_DEVIATION_HIGH

4286: ,EAM_ACT_NOTIFICATION_FLAG
4287: ,EAM_ACT_SHUTDOWN_STATUS
4288: ,DUAL_UOM_CONTROL
4289: ,SECONDARY_UOM_CODE
4290: ,DUAL_UOM_DEVIATION_HIGH
4291: ,DUAL_UOM_DEVIATION_LOW
4292: --
4293: ,CONTRACT_ITEM_TYPE_CODE
4294: ,SUBSCRIPTION_DEPEND_FLAG

Line 4291: ,DUAL_UOM_DEVIATION_LOW

4287: ,EAM_ACT_SHUTDOWN_STATUS
4288: ,DUAL_UOM_CONTROL
4289: ,SECONDARY_UOM_CODE
4290: ,DUAL_UOM_DEVIATION_HIGH
4291: ,DUAL_UOM_DEVIATION_LOW
4292: --
4293: ,CONTRACT_ITEM_TYPE_CODE
4294: ,SUBSCRIPTION_DEPEND_FLAG
4295: --

Line 4690: ,l_Item_rec.DUAL_UOM_CONTROL

4686: ,l_Item_rec.EAM_ACTIVITY_TYPE_CODE
4687: ,l_Item_rec.EAM_ACTIVITY_CAUSE_CODE
4688: ,l_Item_rec.EAM_ACT_NOTIFICATION_FLAG
4689: ,l_Item_rec.EAM_ACT_SHUTDOWN_STATUS
4690: ,l_Item_rec.DUAL_UOM_CONTROL
4691: ,l_Item_rec.SECONDARY_UOM_CODE
4692: ,l_Item_rec.DUAL_UOM_DEVIATION_HIGH
4693: ,l_Item_rec.DUAL_UOM_DEVIATION_LOW
4694: --

Line 4692: ,l_Item_rec.DUAL_UOM_DEVIATION_HIGH

4688: ,l_Item_rec.EAM_ACT_NOTIFICATION_FLAG
4689: ,l_Item_rec.EAM_ACT_SHUTDOWN_STATUS
4690: ,l_Item_rec.DUAL_UOM_CONTROL
4691: ,l_Item_rec.SECONDARY_UOM_CODE
4692: ,l_Item_rec.DUAL_UOM_DEVIATION_HIGH
4693: ,l_Item_rec.DUAL_UOM_DEVIATION_LOW
4694: --
4695: ,DECODE(l_Contract_Item_Type_Code, g_Null_CHAR, g_Upd_Null_CHAR, g_MISS_CHAR, NULL, l_Contract_Item_Type_Code)
4696: ,l_Item_rec.SUBSCRIPTION_DEPEND_FLAG

Line 4693: ,l_Item_rec.DUAL_UOM_DEVIATION_LOW

4689: ,l_Item_rec.EAM_ACT_SHUTDOWN_STATUS
4690: ,l_Item_rec.DUAL_UOM_CONTROL
4691: ,l_Item_rec.SECONDARY_UOM_CODE
4692: ,l_Item_rec.DUAL_UOM_DEVIATION_HIGH
4693: ,l_Item_rec.DUAL_UOM_DEVIATION_LOW
4694: --
4695: ,DECODE(l_Contract_Item_Type_Code, g_Null_CHAR, g_Upd_Null_CHAR, g_MISS_CHAR, NULL, l_Contract_Item_Type_Code)
4696: ,l_Item_rec.SUBSCRIPTION_DEPEND_FLAG
4697: --