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 274: , MSI.DUAL_UOM_CONTROL

270: , MSI.EAM_ACTIVITY_TYPE_CODE
271: , MSI.EAM_ACTIVITY_CAUSE_CODE
272: , MSI.EAM_ACT_NOTIFICATION_FLAG
273: , MSI.EAM_ACT_SHUTDOWN_STATUS
274: , MSI.DUAL_UOM_CONTROL
275: , MSI.SECONDARY_UOM_CODE
276: , MSI.DUAL_UOM_DEVIATION_HIGH
277: , MSI.DUAL_UOM_DEVIATION_LOW
278: --

Line 276: , MSI.DUAL_UOM_DEVIATION_HIGH

272: , MSI.EAM_ACT_NOTIFICATION_FLAG
273: , MSI.EAM_ACT_SHUTDOWN_STATUS
274: , MSI.DUAL_UOM_CONTROL
275: , MSI.SECONDARY_UOM_CODE
276: , MSI.DUAL_UOM_DEVIATION_HIGH
277: , MSI.DUAL_UOM_DEVIATION_LOW
278: --
279: , MSI.SERVICE_ITEM_FLAG
280: , MSI.VENDOR_WARRANTY_FLAG

Line 277: , MSI.DUAL_UOM_DEVIATION_LOW

273: , MSI.EAM_ACT_SHUTDOWN_STATUS
274: , MSI.DUAL_UOM_CONTROL
275: , MSI.SECONDARY_UOM_CODE
276: , MSI.DUAL_UOM_DEVIATION_HIGH
277: , MSI.DUAL_UOM_DEVIATION_LOW
278: --
279: , MSI.SERVICE_ITEM_FLAG
280: , MSI.VENDOR_WARRANTY_FLAG
281: , MSI.USAGE_ITEM_FLAG

Line 1180: FROM dual;

1176: -- Get unique process set id for one record processing.
1177:
1178: SELECT mtl_system_items_intf_sets_s.NEXTVAL
1179: INTO l_set_process_id
1180: FROM dual;
1181:
1182: x_set_process_id := l_set_process_id;
1183:
1184: --5565453 : Appsperf issues reducing the shared memory.

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

2621: ELSIF p_Item_rec.EAM_ACT_SHUTDOWN_STATUS = g_MISS_CHAR THEN
2622: l_Item_rec.EAM_ACT_SHUTDOWN_STATUS := null;
2623: END IF;
2624:
2625: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN
2626: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;
2627: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN
2628: l_Item_rec.DUAL_UOM_CONTROL := null;
2629: END IF;

Line 2626: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;

2622: l_Item_rec.EAM_ACT_SHUTDOWN_STATUS := null;
2623: END IF;
2624:
2625: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN
2626: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;
2627: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN
2628: l_Item_rec.DUAL_UOM_CONTROL := null;
2629: END IF;
2630:

Line 2627: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN

2623: END IF;
2624:
2625: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN
2626: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;
2627: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN
2628: l_Item_rec.DUAL_UOM_CONTROL := null;
2629: END IF;
2630:
2631: IF(p_Item_rec.SECONDARY_UOM_CODE IS NULL) THEN

Line 2628: l_Item_rec.DUAL_UOM_CONTROL := null;

2624:
2625: IF(p_Item_rec.DUAL_UOM_CONTROL IS NULL ) THEN
2626: l_Item_rec.DUAL_UOM_CONTROL := g_Upd_Null_NUM ;
2627: ELSIF p_Item_rec.DUAL_UOM_CONTROL = g_MISS_NUM THEN
2628: l_Item_rec.DUAL_UOM_CONTROL := null;
2629: END IF;
2630:
2631: IF(p_Item_rec.SECONDARY_UOM_CODE IS NULL) THEN
2632: l_Item_rec.SECONDARY_UOM_CODE := g_Upd_Null_CHAR;

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

2633: ELSIF p_Item_rec.SECONDARY_UOM_CODE = g_MISS_CHAR THEN
2634: l_Item_rec.SECONDARY_UOM_CODE := null;
2635: END IF;
2636:
2637: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN
2638: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;
2639: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
2640: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
2641: END IF;

Line 2638: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;

2634: l_Item_rec.SECONDARY_UOM_CODE := null;
2635: END IF;
2636:
2637: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN
2638: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;
2639: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
2640: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
2641: END IF;
2642:

Line 2639: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN

2635: END IF;
2636:
2637: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN
2638: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;
2639: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
2640: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
2641: END IF;
2642:
2643: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN

Line 2640: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;

2636:
2637: IF(p_Item_rec.DUAL_UOM_DEVIATION_HIGH IS NULL ) THEN
2638: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := g_Upd_Null_NUM ;
2639: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
2640: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
2641: END IF;
2642:
2643: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
2644: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;

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

2639: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_HIGH = g_MISS_NUM THEN
2640: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
2641: END IF;
2642:
2643: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
2644: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;
2645: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN
2646: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;
2647: END IF;

Line 2644: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;

2640: l_Item_rec.DUAL_UOM_DEVIATION_HIGH := null;
2641: END IF;
2642:
2643: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
2644: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;
2645: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN
2646: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;
2647: END IF;
2648:

Line 2645: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN

2641: END IF;
2642:
2643: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
2644: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;
2645: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN
2646: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;
2647: END IF;
2648:
2649: IF(p_Item_rec.SUBSCRIPTION_DEPEND_FLAG IS NULL) THEN

Line 2646: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;

2642:
2643: IF(p_Item_rec.DUAL_UOM_DEVIATION_LOW IS NULL ) THEN
2644: l_Item_rec.DUAL_UOM_DEVIATION_LOW := g_Upd_Null_NUM ;
2645: ELSIF p_Item_rec.DUAL_UOM_DEVIATION_LOW = g_MISS_NUM THEN
2646: l_Item_rec.DUAL_UOM_DEVIATION_LOW := null;
2647: END IF;
2648:
2649: IF(p_Item_rec.SUBSCRIPTION_DEPEND_FLAG IS NULL) THEN
2650: l_Item_rec.SUBSCRIPTION_DEPEND_FLAG := g_Upd_Null_CHAR;

Line 3674: ,DUAL_UOM_CONTROL

3670: ,EAM_ACTIVITY_TYPE_CODE
3671: ,EAM_ACTIVITY_CAUSE_CODE
3672: ,EAM_ACT_NOTIFICATION_FLAG
3673: ,EAM_ACT_SHUTDOWN_STATUS
3674: ,DUAL_UOM_CONTROL
3675: ,SECONDARY_UOM_CODE
3676: ,DUAL_UOM_DEVIATION_HIGH
3677: ,DUAL_UOM_DEVIATION_LOW
3678: --

Line 3676: ,DUAL_UOM_DEVIATION_HIGH

3672: ,EAM_ACT_NOTIFICATION_FLAG
3673: ,EAM_ACT_SHUTDOWN_STATUS
3674: ,DUAL_UOM_CONTROL
3675: ,SECONDARY_UOM_CODE
3676: ,DUAL_UOM_DEVIATION_HIGH
3677: ,DUAL_UOM_DEVIATION_LOW
3678: --
3679: ,CONTRACT_ITEM_TYPE_CODE
3680: ,SUBSCRIPTION_DEPEND_FLAG

Line 3677: ,DUAL_UOM_DEVIATION_LOW

3673: ,EAM_ACT_SHUTDOWN_STATUS
3674: ,DUAL_UOM_CONTROL
3675: ,SECONDARY_UOM_CODE
3676: ,DUAL_UOM_DEVIATION_HIGH
3677: ,DUAL_UOM_DEVIATION_LOW
3678: --
3679: ,CONTRACT_ITEM_TYPE_CODE
3680: ,SUBSCRIPTION_DEPEND_FLAG
3681: --

Line 4076: ,l_Item_rec.DUAL_UOM_CONTROL

4072: ,l_Item_rec.EAM_ACTIVITY_TYPE_CODE
4073: ,l_Item_rec.EAM_ACTIVITY_CAUSE_CODE
4074: ,l_Item_rec.EAM_ACT_NOTIFICATION_FLAG
4075: ,l_Item_rec.EAM_ACT_SHUTDOWN_STATUS
4076: ,l_Item_rec.DUAL_UOM_CONTROL
4077: ,l_Item_rec.SECONDARY_UOM_CODE
4078: ,l_Item_rec.DUAL_UOM_DEVIATION_HIGH
4079: ,l_Item_rec.DUAL_UOM_DEVIATION_LOW
4080: --

Line 4078: ,l_Item_rec.DUAL_UOM_DEVIATION_HIGH

4074: ,l_Item_rec.EAM_ACT_NOTIFICATION_FLAG
4075: ,l_Item_rec.EAM_ACT_SHUTDOWN_STATUS
4076: ,l_Item_rec.DUAL_UOM_CONTROL
4077: ,l_Item_rec.SECONDARY_UOM_CODE
4078: ,l_Item_rec.DUAL_UOM_DEVIATION_HIGH
4079: ,l_Item_rec.DUAL_UOM_DEVIATION_LOW
4080: --
4081: ,DECODE(l_Contract_Item_Type_Code, g_Null_CHAR, g_Upd_Null_CHAR, g_MISS_CHAR, NULL, l_Contract_Item_Type_Code)
4082: ,l_Item_rec.SUBSCRIPTION_DEPEND_FLAG

Line 4079: ,l_Item_rec.DUAL_UOM_DEVIATION_LOW

4075: ,l_Item_rec.EAM_ACT_SHUTDOWN_STATUS
4076: ,l_Item_rec.DUAL_UOM_CONTROL
4077: ,l_Item_rec.SECONDARY_UOM_CODE
4078: ,l_Item_rec.DUAL_UOM_DEVIATION_HIGH
4079: ,l_Item_rec.DUAL_UOM_DEVIATION_LOW
4080: --
4081: ,DECODE(l_Contract_Item_Type_Code, g_Null_CHAR, g_Upd_Null_CHAR, g_MISS_CHAR, NULL, l_Contract_Item_Type_Code)
4082: ,l_Item_rec.SUBSCRIPTION_DEPEND_FLAG
4083: --