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 1025: FROM DUAL;

1021: DECODE(p_segment18,fnd_api.g_miss_char,'',NULL,'',p_segment18) ||
1022: DECODE(p_segment19,fnd_api.g_miss_char,'',NULL,'',p_segment19) ||
1023: DECODE(p_segment20,fnd_api.g_miss_char,'',NULL,'',p_segment20)
1024: INTO l_item_number
1025: FROM DUAL;
1026: RETURN l_item_number;
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: RETURN NULL;

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

1644: ,p_eam_activity_type_code => l_item.asset_obj_type.eam_activity_type_code
1645: ,p_eam_activity_cause_code => l_item.asset_obj_type.eam_activity_cause_code
1646: ,p_eam_act_notification_flag => l_item.asset_obj_type.eam_act_notification_flag
1647: ,p_eam_act_shutdown_status => l_item.asset_obj_type.eam_act_shutdown_status
1648: ,p_dual_uom_control => l_item.deprecated_obj_type.dual_uom_control
1649: ,p_secondary_uom_code => l_item.main_obj_type.secondary_uom_code
1650: ,p_dual_uom_deviation_high => l_item.main_obj_type.dual_uom_deviation_high
1651: ,p_dual_uom_deviation_low => l_item.main_obj_type.dual_uom_deviation_low
1652: ,p_contract_item_type_code => l_item.asset_obj_type.contract_item_type_code

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

1646: ,p_eam_act_notification_flag => l_item.asset_obj_type.eam_act_notification_flag
1647: ,p_eam_act_shutdown_status => l_item.asset_obj_type.eam_act_shutdown_status
1648: ,p_dual_uom_control => l_item.deprecated_obj_type.dual_uom_control
1649: ,p_secondary_uom_code => l_item.main_obj_type.secondary_uom_code
1650: ,p_dual_uom_deviation_high => l_item.main_obj_type.dual_uom_deviation_high
1651: ,p_dual_uom_deviation_low => l_item.main_obj_type.dual_uom_deviation_low
1652: ,p_contract_item_type_code => l_item.asset_obj_type.contract_item_type_code
1653: ,p_subscription_depend_flag => l_item.deprecated_obj_type.subscription_depend_flag
1654: ,p_serv_req_enabled_code => l_item.asset_obj_type.serv_req_enabled_code

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

1647: ,p_eam_act_shutdown_status => l_item.asset_obj_type.eam_act_shutdown_status
1648: ,p_dual_uom_control => l_item.deprecated_obj_type.dual_uom_control
1649: ,p_secondary_uom_code => l_item.main_obj_type.secondary_uom_code
1650: ,p_dual_uom_deviation_high => l_item.main_obj_type.dual_uom_deviation_high
1651: ,p_dual_uom_deviation_low => l_item.main_obj_type.dual_uom_deviation_low
1652: ,p_contract_item_type_code => l_item.asset_obj_type.contract_item_type_code
1653: ,p_subscription_depend_flag => l_item.deprecated_obj_type.subscription_depend_flag
1654: ,p_serv_req_enabled_code => l_item.asset_obj_type.serv_req_enabled_code
1655: ,p_serv_billing_enabled_flag => l_item.asset_obj_type.serv_billing_enabled_flag

Line 3689: ,dual_uom_deviation_high

3685: ,tracking_quantity_ind
3686: ,ont_pricing_qty_source
3687: ,secondary_uom_code
3688: ,secondary_default_ind
3689: ,dual_uom_deviation_high
3690: ,dual_uom_deviation_low
3691: ,allowed_units_lookup_code
3692: ,item_type
3693: ,description

Line 3690: ,dual_uom_deviation_low

3686: ,ont_pricing_qty_source
3687: ,secondary_uom_code
3688: ,secondary_default_ind
3689: ,dual_uom_deviation_high
3690: ,dual_uom_deviation_low
3691: ,allowed_units_lookup_code
3692: ,item_type
3693: ,description
3694: ,inventory_item_status_code

Line 3981: ,l_item_core_obj.dual_uom_deviation_high

3977: ,l_item_core_obj.tracking_quantity_ind
3978: ,l_item_core_obj.ont_pricing_qty_source
3979: ,l_item_core_obj.secondary_uom_code
3980: ,l_item_core_obj.secondary_default_ind
3981: ,l_item_core_obj.dual_uom_deviation_high
3982: ,l_item_core_obj.dual_uom_deviation_low
3983: ,l_item_core_obj.allowed_units_lookup_code
3984: ,l_item_core_obj.item_type
3985: ,l_item_core_obj.description

Line 3982: ,l_item_core_obj.dual_uom_deviation_low

3978: ,l_item_core_obj.ont_pricing_qty_source
3979: ,l_item_core_obj.secondary_uom_code
3980: ,l_item_core_obj.secondary_default_ind
3981: ,l_item_core_obj.dual_uom_deviation_high
3982: ,l_item_core_obj.dual_uom_deviation_low
3983: ,l_item_core_obj.allowed_units_lookup_code
3984: ,l_item_core_obj.item_type
3985: ,l_item_core_obj.description
3986: ,l_item_core_obj.inventory_item_status_code

Line 5000: FROM dual ) a

4996: SELECT inv_ebi_get_operational_attrs(item_flst.item_id,item_flst.item_name,item_flst.organization_id,item_flst.organization_code,NULL,NULL)
4997: FROM (
4998: SELECT a.item_id,a.item_name, a.organization_id,a.organization_code
4999: FROM THE (SELECT CAST( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
5000: FROM dual ) a
5001: INTERSECT
5002: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
5003: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
5004: FROM dual ) b

Line 5004: FROM dual ) b

5000: FROM dual ) a
5001: INTERSECT
5002: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
5003: FROM THE (SELECT CAST( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
5004: FROM dual ) b
5005: ) item_flst;
5006: BEGIN
5007: FND_MSG_PUB.initialize();
5008: x_return_status := FND_API.g_ret_sts_success;

Line 5184: FROM dual ) a

5180: SELECT inv_ebi_get_operational_attrs(gibf.item_id,gibf.item_name, gibf.organization_id,gibf.organization_code,NULL,NULL)
5181: FROM (
5182: SELECT a.item_id,a.item_name, a.organization_id,a.organization_code
5183: FROM THE (SELECT cast( l_item_output_tbl as inv_ebi_get_opr_attrs_tbl)
5184: FROM dual ) a
5185: INTERSECT
5186: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
5187: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
5188: FROM dual ) b ) gibf;

Line 5188: FROM dual ) b ) gibf;

5184: FROM dual ) a
5185: INTERSECT
5186: SELECT b.item_id,b.item_name, b.organization_id,b.organization_code
5187: FROM THE (SELECT cast( l_item_tbl as inv_ebi_get_opr_attrs_tbl)
5188: FROM dual ) b ) gibf;
5189:
5190: BEGIN
5191: FND_MSG_PUB.initialize();
5192: x_return_status := FND_API.g_ret_sts_success;

Line 5355: FROM DUAL;

5351: AND UPPER(enabled_flag)='Y';
5352:
5353: SELECT TZ_OFFSET(l_server_tz)
5354: INTO l_tzoffset
5355: FROM DUAL;
5356:
5357: INV_EBI_ITEM_HELPER.G_TIME_ZONE_OFFSET := l_tzoffset;
5358:
5359: EXCEPTION