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

Line 28: ,p_dual_uom_deviation_high IN NUMBER

24: ,x_error_code OUT NOCOPY VARCHAR2
25: ,p_secondary_uom_code IN VARCHAR2
26: ,p_secondary_default_ind IN VARCHAR2
27: ,p_ont_pricing_qty_source IN VARCHAR2
28: ,p_dual_uom_deviation_high IN NUMBER
29: ,p_dual_uom_deviation_low IN NUMBER
30: ,p_serial_number_control_code IN NUMBER
31: ,p_tax_code IN VARCHAR2
32: ,p_master_status IN VARCHAR2

Line 29: ,p_dual_uom_deviation_low IN NUMBER

25: ,p_secondary_uom_code IN VARCHAR2
26: ,p_secondary_default_ind IN VARCHAR2
27: ,p_ont_pricing_qty_source IN VARCHAR2
28: ,p_dual_uom_deviation_high IN NUMBER
29: ,p_dual_uom_deviation_low IN NUMBER
30: ,p_serial_number_control_code IN NUMBER
31: ,p_tax_code IN VARCHAR2
32: ,p_master_status IN VARCHAR2
33: ,p_base_item_id IN NUMBER DEFAULT NULL

Line 176: IF ( p_dual_uom_deviation_high <> 0

172: END IF;
173: Raise FND_API.g_EXC_ERROR;
174: END IF;
175:
176: IF ( p_dual_uom_deviation_high <> 0
177: OR p_dual_uom_deviation_low <> 0 )THEN
178: x_msg_count := x_msg_count + 1;
179: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
180: IF NVL(p_context,'N') = 'N' THEN

Line 177: OR p_dual_uom_deviation_low <> 0 )THEN

173: Raise FND_API.g_EXC_ERROR;
174: END IF;
175:
176: IF ( p_dual_uom_deviation_high <> 0
177: OR p_dual_uom_deviation_low <> 0 )THEN
178: x_msg_count := x_msg_count + 1;
179: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
180: IF NVL(p_context,'N') = 'N' THEN
181: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

Line 233: IF ( p_dual_uom_deviation_high <> 0 OR p_dual_uom_deviation_low <> 0 )THEN

229: -- Confirming if "Positive Deviation" and "Negative Deviation" are 0
230: -- when "Defaulting" is neither "Default" nor "Not Default"
231: IF ( p_secondary_default_ind NOT IN ('D','N') ) THEN
232: --{
233: IF ( p_dual_uom_deviation_high <> 0 OR p_dual_uom_deviation_low <> 0 )THEN
234: --{
235: x_msg_count := x_msg_count + 1;
236: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
237: IF NVL(p_context,'N') = 'N' THEN

Line 366: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH

362: ,A.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
363: ,A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND
364: ,A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
365: ,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
366: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
367: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
368: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
369: FROM dual) A
370: ORDER BY INVENTORY_ITEM_ID;

Line 367: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW

363: ,A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND
364: ,A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
365: ,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
366: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
367: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
368: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
369: FROM dual) A
370: ORDER BY INVENTORY_ITEM_ID;
371:

Line 369: FROM dual) A

365: ,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
366: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
367: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
368: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
369: FROM dual) A
370: ORDER BY INVENTORY_ITEM_ID;
371:
372: l_error_code VARCHAR2(2000);
373: l_status VARCHAR2(1);

Line 441: l_item_rec.dual_uom_deviation_high := NVL(org_assign_rec.dual_uom_deviation_high,0);

437: l_item_rec.secondary_uom_code := org_assign_rec.secondary_uom_code;
438: l_item_rec.tracking_quantity_ind := org_assign_rec.tracking_quantity_ind;
439: l_item_rec.secondary_default_ind := org_assign_rec.secondary_default_ind;
440: l_item_rec.ont_pricing_qty_source := org_assign_rec.ont_pricing_qty_source;
441: l_item_rec.dual_uom_deviation_high := NVL(org_assign_rec.dual_uom_deviation_high,0);
442: l_item_rec.dual_uom_deviation_low := NVL(org_assign_rec.dual_uom_deviation_low,0);
443:
444: /* Bug 7419728 : Added the below sql */
445: SELECT DECODE(l_item_rec.tracking_quantity_ind,'P',1,

Line 442: l_item_rec.dual_uom_deviation_low := NVL(org_assign_rec.dual_uom_deviation_low,0);

438: l_item_rec.tracking_quantity_ind := org_assign_rec.tracking_quantity_ind;
439: l_item_rec.secondary_default_ind := org_assign_rec.secondary_default_ind;
440: l_item_rec.ont_pricing_qty_source := org_assign_rec.ont_pricing_qty_source;
441: l_item_rec.dual_uom_deviation_high := NVL(org_assign_rec.dual_uom_deviation_high,0);
442: l_item_rec.dual_uom_deviation_low := NVL(org_assign_rec.dual_uom_deviation_low,0);
443:
444: /* Bug 7419728 : Added the below sql */
445: SELECT DECODE(l_item_rec.tracking_quantity_ind,'P',1,
446: DECODE(NVL(l_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))

Line 447: INTO l_item_rec.DUAL_UOM_CONTROL

443:
444: /* Bug 7419728 : Added the below sql */
445: SELECT DECODE(l_item_rec.tracking_quantity_ind,'P',1,
446: DECODE(NVL(l_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))
447: INTO l_item_rec.DUAL_UOM_CONTROL
448: FROM DUAL;
449:
450: l_item_rec.last_updated_by := FND_GLOBAL.User_Id;
451: l_item_rec.created_by := FND_GLOBAL.User_Id;

Line 448: FROM DUAL;

444: /* Bug 7419728 : Added the below sql */
445: SELECT DECODE(l_item_rec.tracking_quantity_ind,'P',1,
446: DECODE(NVL(l_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))
447: INTO l_item_rec.DUAL_UOM_CONTROL
448: FROM DUAL;
449:
450: l_item_rec.last_updated_by := FND_GLOBAL.User_Id;
451: l_item_rec.created_by := FND_GLOBAL.User_Id;
452:

Line 523: ,p_dual_uom_deviation_high => l_item_rec.dual_uom_deviation_high

519: ,x_error_code => l_error_code
520: ,p_secondary_uom_code => l_item_rec.secondary_uom_code
521: ,p_secondary_default_ind => l_item_rec.secondary_default_ind
522: ,p_ont_pricing_qty_source => l_item_rec.ont_pricing_qty_source
523: ,p_dual_uom_deviation_high => l_item_rec.dual_uom_deviation_high
524: ,p_dual_uom_deviation_low => l_item_rec.dual_uom_deviation_low
525: ,p_serial_number_control_code => l_item_rec.serial_number_control_code
526: ,p_tax_code => l_item_rec.tax_code
527: ,p_master_status => l_master_status

Line 524: ,p_dual_uom_deviation_low => l_item_rec.dual_uom_deviation_low

520: ,p_secondary_uom_code => l_item_rec.secondary_uom_code
521: ,p_secondary_default_ind => l_item_rec.secondary_default_ind
522: ,p_ont_pricing_qty_source => l_item_rec.ont_pricing_qty_source
523: ,p_dual_uom_deviation_high => l_item_rec.dual_uom_deviation_high
524: ,p_dual_uom_deviation_low => l_item_rec.dual_uom_deviation_low
525: ,p_serial_number_control_code => l_item_rec.serial_number_control_code
526: ,p_tax_code => l_item_rec.tax_code
527: ,p_master_status => l_master_status
528: ,p_base_item_id => l_item_rec.base_item_id --Bug: 5438006 Added base_item_id

Line 856: ,b.dual_uom_control

852: ,b.eam_activity_type_code
853: ,b.eam_activity_cause_code
854: ,b.eam_act_notification_flag
855: ,b.eam_act_shutdown_status
856: ,b.dual_uom_control
857: ,b.secondary_uom_code
858: ,b.dual_uom_deviation_high
859: ,b.dual_uom_deviation_low
860: ,b.contract_item_type_code

Line 858: ,b.dual_uom_deviation_high

854: ,b.eam_act_notification_flag
855: ,b.eam_act_shutdown_status
856: ,b.dual_uom_control
857: ,b.secondary_uom_code
858: ,b.dual_uom_deviation_high
859: ,b.dual_uom_deviation_low
860: ,b.contract_item_type_code
861: ,b.subscription_depend_flag
862: ,b.serv_req_enabled_code

Line 859: ,b.dual_uom_deviation_low

855: ,b.eam_act_shutdown_status
856: ,b.dual_uom_control
857: ,b.secondary_uom_code
858: ,b.dual_uom_deviation_high
859: ,b.dual_uom_deviation_low
860: ,b.contract_item_type_code
861: ,b.subscription_depend_flag
862: ,b.serv_req_enabled_code
863: ,b.serv_billing_enabled_flag

Line 1216: ,p_item_rec.dual_uom_control

1212: ,p_item_rec.eam_activity_type_code
1213: ,p_item_rec.eam_activity_cause_code
1214: ,p_item_rec.eam_act_notification_flag
1215: ,p_item_rec.eam_act_shutdown_status
1216: ,p_item_rec.dual_uom_control
1217: ,p_item_rec.secondary_uom_code
1218: ,p_item_rec.dual_uom_deviation_high
1219: ,p_item_rec.dual_uom_deviation_low
1220: ,p_item_rec.contract_item_type_code

Line 1218: ,p_item_rec.dual_uom_deviation_high

1214: ,p_item_rec.eam_act_notification_flag
1215: ,p_item_rec.eam_act_shutdown_status
1216: ,p_item_rec.dual_uom_control
1217: ,p_item_rec.secondary_uom_code
1218: ,p_item_rec.dual_uom_deviation_high
1219: ,p_item_rec.dual_uom_deviation_low
1220: ,p_item_rec.contract_item_type_code
1221: ,p_item_rec.subscription_depend_flag
1222: ,p_item_rec.serv_req_enabled_code

Line 1219: ,p_item_rec.dual_uom_deviation_low

1215: ,p_item_rec.eam_act_shutdown_status
1216: ,p_item_rec.dual_uom_control
1217: ,p_item_rec.secondary_uom_code
1218: ,p_item_rec.dual_uom_deviation_high
1219: ,p_item_rec.dual_uom_deviation_low
1220: ,p_item_rec.contract_item_type_code
1221: ,p_item_rec.subscription_depend_flag
1222: ,p_item_rec.serv_req_enabled_code
1223: ,p_item_rec.serv_billing_enabled_flag

Line 1350: INTO p_item_rec.DUAL_UOM_CONTROL

1346:
1347: /* Bug 7419728 : Commented the below sql */
1348: /* SELECT DECODE(p_item_rec.tracking_quantity_ind,'P',1,
1349: DECODE(NVL(p_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))
1350: INTO p_item_rec.DUAL_UOM_CONTROL
1351: FROM DUAL; */
1352:
1353:
1354: p_item_rec.process_supply_subinventory := NULL;

Line 1351: FROM DUAL; */

1347: /* Bug 7419728 : Commented the below sql */
1348: /* SELECT DECODE(p_item_rec.tracking_quantity_ind,'P',1,
1349: DECODE(NVL(p_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))
1350: INTO p_item_rec.DUAL_UOM_CONTROL
1351: FROM DUAL; */
1352:
1353:
1354: p_item_rec.process_supply_subinventory := NULL;
1355: p_item_rec.process_supply_locator_id := NULL;