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_EBI_ITEM_HELPER dependencies on DUAL

Line 604: SELECT Length(l_rate_in_tbl)-InStr(l_rate_in_tbl,'.') INTO l_length1 FROM dual;

600: l_rate_in_tbl NUMBER;
601: BEGIN
602: l_conv_rate_calc := (((p_conv_rate_from_uom1_uom2 ) * p_convrate_from_unit_to_bu)/p_conv_rate_from_bu1_to_bu2);
603: l_rate_in_tbl := p_conv_rate_from_unit1_to_bu1;
604: SELECT Length(l_rate_in_tbl)-InStr(l_rate_in_tbl,'.') INTO l_length1 FROM dual;
605: SELECT Length(l_conv_rate_calc)-InStr(l_conv_rate_calc,'.') INTO l_length2 FROM dual;
606: IF l_length1<=l_length2 THEN
607: SELECT Round(l_conv_rate_calc,l_length1) INTO l_conv_rate_calc FROM dual;
608: ELSE

Line 605: SELECT Length(l_conv_rate_calc)-InStr(l_conv_rate_calc,'.') INTO l_length2 FROM dual;

601: BEGIN
602: l_conv_rate_calc := (((p_conv_rate_from_uom1_uom2 ) * p_convrate_from_unit_to_bu)/p_conv_rate_from_bu1_to_bu2);
603: l_rate_in_tbl := p_conv_rate_from_unit1_to_bu1;
604: SELECT Length(l_rate_in_tbl)-InStr(l_rate_in_tbl,'.') INTO l_length1 FROM dual;
605: SELECT Length(l_conv_rate_calc)-InStr(l_conv_rate_calc,'.') INTO l_length2 FROM dual;
606: IF l_length1<=l_length2 THEN
607: SELECT Round(l_conv_rate_calc,l_length1) INTO l_conv_rate_calc FROM dual;
608: ELSE
609: SELECT Round(l_rate_in_tbl,l_length2) INTO l_rate_in_tbl FROM dual;

Line 607: SELECT Round(l_conv_rate_calc,l_length1) INTO l_conv_rate_calc FROM dual;

603: l_rate_in_tbl := p_conv_rate_from_unit1_to_bu1;
604: SELECT Length(l_rate_in_tbl)-InStr(l_rate_in_tbl,'.') INTO l_length1 FROM dual;
605: SELECT Length(l_conv_rate_calc)-InStr(l_conv_rate_calc,'.') INTO l_length2 FROM dual;
606: IF l_length1<=l_length2 THEN
607: SELECT Round(l_conv_rate_calc,l_length1) INTO l_conv_rate_calc FROM dual;
608: ELSE
609: SELECT Round(l_rate_in_tbl,l_length2) INTO l_rate_in_tbl FROM dual;
610: END IF;
611:

Line 609: SELECT Round(l_rate_in_tbl,l_length2) INTO l_rate_in_tbl FROM dual;

605: SELECT Length(l_conv_rate_calc)-InStr(l_conv_rate_calc,'.') INTO l_length2 FROM dual;
606: IF l_length1<=l_length2 THEN
607: SELECT Round(l_conv_rate_calc,l_length1) INTO l_conv_rate_calc FROM dual;
608: ELSE
609: SELECT Round(l_rate_in_tbl,l_length2) INTO l_rate_in_tbl FROM dual;
610: END IF;
611:
612: if(l_conv_rate_calc = l_rate_in_tbl ) then
613: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1300: FROM DUAL;

1296: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1297: DECODE(p_segment19,fnd_api.g_miss_char,'',NULL,'',p_segment19) ||
1298: DECODE(p_segment20,fnd_api.g_miss_char,'',NULL,'',p_segment20)
1299: INTO l_item_number
1300: FROM DUAL;
1301: RETURN l_item_number;
1302: EXCEPTION
1303: WHEN OTHERS THEN
1304: RETURN NULL;

Line 2239: ,p_dual_uom_control => l_item.deprecated_obj_type.dual_uom_control

2235: ,p_eam_activity_type_code => l_item.asset_obj_type.eam_activity_type_code
2236: ,p_eam_activity_cause_code => l_item.asset_obj_type.eam_activity_cause_code
2237: ,p_eam_act_notification_flag => l_item.asset_obj_type.eam_act_notification_flag
2238: ,p_eam_act_shutdown_status => l_item.asset_obj_type.eam_act_shutdown_status
2239: ,p_dual_uom_control => l_item.deprecated_obj_type.dual_uom_control
2240: ,p_secondary_uom_code => l_item.main_obj_type.secondary_uom_code
2241: ,p_dual_uom_deviation_high => l_item.main_obj_type.dual_uom_deviation_high
2242: ,p_dual_uom_deviation_low => l_item.main_obj_type.dual_uom_deviation_low
2243: ,p_contract_item_type_code => l_item.asset_obj_type.contract_item_type_code

Line 2241: ,p_dual_uom_deviation_high => l_item.main_obj_type.dual_uom_deviation_high

2237: ,p_eam_act_notification_flag => l_item.asset_obj_type.eam_act_notification_flag
2238: ,p_eam_act_shutdown_status => l_item.asset_obj_type.eam_act_shutdown_status
2239: ,p_dual_uom_control => l_item.deprecated_obj_type.dual_uom_control
2240: ,p_secondary_uom_code => l_item.main_obj_type.secondary_uom_code
2241: ,p_dual_uom_deviation_high => l_item.main_obj_type.dual_uom_deviation_high
2242: ,p_dual_uom_deviation_low => l_item.main_obj_type.dual_uom_deviation_low
2243: ,p_contract_item_type_code => l_item.asset_obj_type.contract_item_type_code
2244: ,p_subscription_depend_flag => l_item.deprecated_obj_type.subscription_depend_flag
2245: ,p_serv_req_enabled_code => l_item.asset_obj_type.serv_req_enabled_code

Line 2242: ,p_dual_uom_deviation_low => l_item.main_obj_type.dual_uom_deviation_low

2238: ,p_eam_act_shutdown_status => l_item.asset_obj_type.eam_act_shutdown_status
2239: ,p_dual_uom_control => l_item.deprecated_obj_type.dual_uom_control
2240: ,p_secondary_uom_code => l_item.main_obj_type.secondary_uom_code
2241: ,p_dual_uom_deviation_high => l_item.main_obj_type.dual_uom_deviation_high
2242: ,p_dual_uom_deviation_low => l_item.main_obj_type.dual_uom_deviation_low
2243: ,p_contract_item_type_code => l_item.asset_obj_type.contract_item_type_code
2244: ,p_subscription_depend_flag => l_item.deprecated_obj_type.subscription_depend_flag
2245: ,p_serv_req_enabled_code => l_item.asset_obj_type.serv_req_enabled_code
2246: ,p_serv_billing_enabled_flag => l_item.asset_obj_type.serv_billing_enabled_flag

Line 5211: ,dual_uom_deviation_high

5207: ,tracking_quantity_ind
5208: ,ont_pricing_qty_source
5209: ,secondary_uom_code
5210: ,secondary_default_ind
5211: ,dual_uom_deviation_high
5212: ,dual_uom_deviation_low
5213: ,allowed_units_lookup_code
5214: ,item_type
5215: ,description

Line 5212: ,dual_uom_deviation_low

5208: ,ont_pricing_qty_source
5209: ,secondary_uom_code
5210: ,secondary_default_ind
5211: ,dual_uom_deviation_high
5212: ,dual_uom_deviation_low
5213: ,allowed_units_lookup_code
5214: ,item_type
5215: ,description
5216: ,inventory_item_status_code

Line 5503: ,l_item_core_obj.dual_uom_deviation_high

5499: ,l_item_core_obj.tracking_quantity_ind
5500: ,l_item_core_obj.ont_pricing_qty_source
5501: ,l_item_core_obj.secondary_uom_code
5502: ,l_item_core_obj.secondary_default_ind
5503: ,l_item_core_obj.dual_uom_deviation_high
5504: ,l_item_core_obj.dual_uom_deviation_low
5505: ,l_item_core_obj.allowed_units_lookup_code
5506: ,l_item_core_obj.item_type
5507: ,l_item_core_obj.description

Line 5504: ,l_item_core_obj.dual_uom_deviation_low

5500: ,l_item_core_obj.ont_pricing_qty_source
5501: ,l_item_core_obj.secondary_uom_code
5502: ,l_item_core_obj.secondary_default_ind
5503: ,l_item_core_obj.dual_uom_deviation_high
5504: ,l_item_core_obj.dual_uom_deviation_low
5505: ,l_item_core_obj.allowed_units_lookup_code
5506: ,l_item_core_obj.item_type
5507: ,l_item_core_obj.description
5508: ,l_item_core_obj.inventory_item_status_code

Line 6512: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

6508: (SELECT mcr.inventory_item_id, msik.concatenated_segments, msi.organization_id, mp.organization_code
6509: FROM mtl_cross_references_b mcr, mtl_system_items_b msi, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6510: WHERE mcr.inventory_item_id = msi.inventory_item_id
6511: --AND mcr.organization_id = msi.organization_id --8897962 mcr has organization_id value as null
6512: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6513: AND hz.orig_system_id = mcr.source_system_id
6514: AND msi.organization_id = mp.organization_id
6515: AND msik.organization_id = msi.organization_id
6516: AND msik.inventory_item_id = msi.inventory_item_id

Line 6529: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

6525: AND msik.organization_id = mp.organization_id
6526: AND msik.organization_id = cic.organization_id
6527: AND msik.inventory_item_id = cic.inventory_item_id
6528: AND cic.last_update_date <> cic.creation_date
6529: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6530: AND hz.orig_system_id = mcr.source_system_id
6531: AND cic.last_update_date >= l_from_date
6532: AND cic.last_update_date <= l_to_date
6533: UNION

Line 6539: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

6535: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6536: WHERE mcr.inventory_item_id = cql.inventory_item_id
6537: --AND mcr.organization_id = cql.organization_id
6538: AND msik.organization_id = mp.organization_id
6539: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6540: AND hz.orig_system_id = mcr.source_system_id
6541: AND msik.organization_id = cql.organization_id
6542: AND msik.inventory_item_id = cql.inventory_item_id
6543: AND cql.last_update_date >= l_from_date

Line 6581: FROM dual ) a

6577: SELECT inv_ebi_get_operational_attrs(item_flst.item_id,item_flst.item_name,item_flst.organization_id,item_flst.organization_code,NULL,NULL)
6578: FROM (
6579: SELECT a.item_id,a.item_name, a.organization_id,a.organization_code
6580: FROM THE (SELECT CAST( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
6581: FROM dual ) a
6582: INTERSECT
6583: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
6584: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
6585: FROM dual ) b

Line 6585: FROM dual ) b

6581: FROM dual ) a
6582: INTERSECT
6583: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
6584: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
6585: FROM dual ) b
6586: ) item_flst;
6587: BEGIN
6588: FND_MSG_PUB.initialize();
6589: INV_EBI_UTIL.setup();

Line 6803: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

6799: --AND mcr.organization_id = moq.organization_id
6800: AND moq.organization_id = mp.organization_id
6801: AND msik.organization_id = moq.organization_id
6802: AND msik.inventory_item_id = moq.inventory_item_id
6803: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))
6804: AND hz.orig_system_id = mcr.source_system_id
6805: AND moq.last_update_date >= l_from_date
6806: AND moq.last_update_date <= l_to_date) gibp;
6807:

Line 6823: FROM dual ) a

6819: SELECT inv_ebi_get_operational_attrs(gibf.item_id,gibf.item_name, gibf.organization_id,gibf.organization_code,NULL,NULL)
6820: FROM (
6821: SELECT a.item_id,a.item_name, a.organization_id,a.organization_code
6822: FROM THE (SELECT cast( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
6823: FROM dual ) a
6824: INTERSECT
6825: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
6826: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
6827: FROM dual ) b ) gibf;

Line 6827: FROM dual ) b ) gibf;

6823: FROM dual ) a
6824: INTERSECT
6825: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
6826: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
6827: FROM dual ) b ) gibf;
6828:
6829: BEGIN
6830: FND_MSG_PUB.initialize();
6831: INV_EBI_UTIL.setup();

Line 7047: FROM DUAL;

7043: AND UPPER(enabled_flag)='Y';
7044:
7045: SELECT TZ_OFFSET(l_server_tz)
7046: INTO l_tzoffset
7047: FROM DUAL;
7048:
7049: INV_EBI_ITEM_HELPER.G_TIME_ZONE_OFFSET := l_tzoffset;
7050:
7051: EXCEPTION