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 164: IF ( p_dual_uom_deviation_high <> 0

160: END IF;
161: Raise FND_API.g_EXC_ERROR;
162: END IF;
163:
164: IF ( p_dual_uom_deviation_high <> 0
165: OR p_dual_uom_deviation_low <> 0 )THEN
166: x_msg_count := x_msg_count + 1;
167: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
168: IF NVL(p_context,'N') = 'N' THEN

Line 165: OR p_dual_uom_deviation_low <> 0 )THEN

161: Raise FND_API.g_EXC_ERROR;
162: END IF;
163:
164: IF ( p_dual_uom_deviation_high <> 0
165: OR p_dual_uom_deviation_low <> 0 )THEN
166: x_msg_count := x_msg_count + 1;
167: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
168: IF NVL(p_context,'N') = 'N' THEN
169: EGO_Item_Msg.Add_Error_Text(x_msg_count,p_org_code ||' : '||fnd_message.get);

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

217: -- Confirming if "Positive Deviation" and "Negative Deviation" are 0
218: -- when "Defaulting" is neither "Default" nor "Not Default"
219: IF ( p_secondary_default_ind NOT IN ('D','N') ) THEN
220: --{
221: IF ( p_dual_uom_deviation_high <> 0 OR p_dual_uom_deviation_low <> 0 )THEN
222: --{
223: x_msg_count := x_msg_count + 1;
224: FND_MESSAGE.SET_NAME('INV','INV_UOM_DEV_IS_NOT_ZERO');
225: IF NVL(p_context,'N') = 'N' THEN

Line 354: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH

350: ,A.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
351: ,A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND
352: ,A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
353: ,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
354: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
355: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
356: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
357: FROM dual) A
358: ORDER BY INVENTORY_ITEM_ID;

Line 355: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW

351: ,A.TRACKING_QUANTITY_IND TRACKING_QUANTITY_IND
352: ,A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
353: ,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
354: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
355: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
356: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
357: FROM dual) A
358: ORDER BY INVENTORY_ITEM_ID;
359:

Line 357: FROM dual) A

353: ,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
354: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
355: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
356: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
357: FROM dual) A
358: ORDER BY INVENTORY_ITEM_ID;
359:
360: l_error_code VARCHAR2(2000);
361: l_status VARCHAR2(1);

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

423: l_item_rec.secondary_uom_code := org_assign_rec.secondary_uom_code;
424: l_item_rec.tracking_quantity_ind := org_assign_rec.tracking_quantity_ind;
425: l_item_rec.secondary_default_ind := org_assign_rec.secondary_default_ind;
426: l_item_rec.ont_pricing_qty_source := org_assign_rec.ont_pricing_qty_source;
427: l_item_rec.dual_uom_deviation_high := NVL(org_assign_rec.dual_uom_deviation_high,0);
428: l_item_rec.dual_uom_deviation_low := NVL(org_assign_rec.dual_uom_deviation_low,0);
429:
430: l_item_rec.last_updated_by := FND_GLOBAL.User_Id;
431: l_item_rec.created_by := FND_GLOBAL.User_Id;

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

424: l_item_rec.tracking_quantity_ind := org_assign_rec.tracking_quantity_ind;
425: l_item_rec.secondary_default_ind := org_assign_rec.secondary_default_ind;
426: l_item_rec.ont_pricing_qty_source := org_assign_rec.ont_pricing_qty_source;
427: l_item_rec.dual_uom_deviation_high := NVL(org_assign_rec.dual_uom_deviation_high,0);
428: l_item_rec.dual_uom_deviation_low := NVL(org_assign_rec.dual_uom_deviation_low,0);
429:
430: l_item_rec.last_updated_by := FND_GLOBAL.User_Id;
431: l_item_rec.created_by := FND_GLOBAL.User_Id;
432:

Line 503: ,p_dual_uom_deviation_high => l_item_rec.dual_uom_deviation_high

499: ,x_error_code => l_error_code
500: ,p_secondary_uom_code => l_item_rec.secondary_uom_code
501: ,p_secondary_default_ind => l_item_rec.secondary_default_ind
502: ,p_ont_pricing_qty_source => l_item_rec.ont_pricing_qty_source
503: ,p_dual_uom_deviation_high => l_item_rec.dual_uom_deviation_high
504: ,p_dual_uom_deviation_low => l_item_rec.dual_uom_deviation_low
505: ,p_serial_number_control_code => l_item_rec.serial_number_control_code
506: ,p_tax_code => l_item_rec.tax_code
507: ,p_master_status => l_master_status

Line 504: ,p_dual_uom_deviation_low => l_item_rec.dual_uom_deviation_low

500: ,p_secondary_uom_code => l_item_rec.secondary_uom_code
501: ,p_secondary_default_ind => l_item_rec.secondary_default_ind
502: ,p_ont_pricing_qty_source => l_item_rec.ont_pricing_qty_source
503: ,p_dual_uom_deviation_high => l_item_rec.dual_uom_deviation_high
504: ,p_dual_uom_deviation_low => l_item_rec.dual_uom_deviation_low
505: ,p_serial_number_control_code => l_item_rec.serial_number_control_code
506: ,p_tax_code => l_item_rec.tax_code
507: ,p_master_status => l_master_status
508: ,p_base_item_id => l_item_rec.base_item_id --Bug: 5438006 Added base_item_id

Line 835: ,b.dual_uom_control

831: ,b.eam_activity_type_code
832: ,b.eam_activity_cause_code
833: ,b.eam_act_notification_flag
834: ,b.eam_act_shutdown_status
835: ,b.dual_uom_control
836: ,b.secondary_uom_code
837: ,b.dual_uom_deviation_high
838: ,b.dual_uom_deviation_low
839: ,b.contract_item_type_code

Line 837: ,b.dual_uom_deviation_high

833: ,b.eam_act_notification_flag
834: ,b.eam_act_shutdown_status
835: ,b.dual_uom_control
836: ,b.secondary_uom_code
837: ,b.dual_uom_deviation_high
838: ,b.dual_uom_deviation_low
839: ,b.contract_item_type_code
840: ,b.subscription_depend_flag
841: ,b.serv_req_enabled_code

Line 838: ,b.dual_uom_deviation_low

834: ,b.eam_act_shutdown_status
835: ,b.dual_uom_control
836: ,b.secondary_uom_code
837: ,b.dual_uom_deviation_high
838: ,b.dual_uom_deviation_low
839: ,b.contract_item_type_code
840: ,b.subscription_depend_flag
841: ,b.serv_req_enabled_code
842: ,b.serv_billing_enabled_flag

Line 1195: ,p_item_rec.dual_uom_control

1191: ,p_item_rec.eam_activity_type_code
1192: ,p_item_rec.eam_activity_cause_code
1193: ,p_item_rec.eam_act_notification_flag
1194: ,p_item_rec.eam_act_shutdown_status
1195: ,p_item_rec.dual_uom_control
1196: ,p_item_rec.secondary_uom_code
1197: ,p_item_rec.dual_uom_deviation_high
1198: ,p_item_rec.dual_uom_deviation_low
1199: ,p_item_rec.contract_item_type_code

Line 1197: ,p_item_rec.dual_uom_deviation_high

1193: ,p_item_rec.eam_act_notification_flag
1194: ,p_item_rec.eam_act_shutdown_status
1195: ,p_item_rec.dual_uom_control
1196: ,p_item_rec.secondary_uom_code
1197: ,p_item_rec.dual_uom_deviation_high
1198: ,p_item_rec.dual_uom_deviation_low
1199: ,p_item_rec.contract_item_type_code
1200: ,p_item_rec.subscription_depend_flag
1201: ,p_item_rec.serv_req_enabled_code

Line 1198: ,p_item_rec.dual_uom_deviation_low

1194: ,p_item_rec.eam_act_shutdown_status
1195: ,p_item_rec.dual_uom_control
1196: ,p_item_rec.secondary_uom_code
1197: ,p_item_rec.dual_uom_deviation_high
1198: ,p_item_rec.dual_uom_deviation_low
1199: ,p_item_rec.contract_item_type_code
1200: ,p_item_rec.subscription_depend_flag
1201: ,p_item_rec.serv_req_enabled_code
1202: ,p_item_rec.serv_billing_enabled_flag

Line 1328: INTO p_item_rec.DUAL_UOM_CONTROL

1324: AND t.language = userenv('LANG');
1325:
1326: SELECT DECODE(p_item_rec.tracking_quantity_ind,'P',1,
1327: DECODE(NVL(p_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))
1328: INTO p_item_rec.DUAL_UOM_CONTROL
1329: FROM DUAL;
1330:
1331:
1332: p_item_rec.process_supply_subinventory := NULL;

Line 1329: FROM DUAL;

1325:
1326: SELECT DECODE(p_item_rec.tracking_quantity_ind,'P',1,
1327: DECODE(NVL(p_item_rec.secondary_default_ind,'X'),'F',2,'D',3,4))
1328: INTO p_item_rec.DUAL_UOM_CONTROL
1329: FROM DUAL;
1330:
1331:
1332: p_item_rec.process_supply_subinventory := NULL;
1333: p_item_rec.process_supply_locator_id := NULL;