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

Line 850: from dual

846: gLoginId, -- last_update_login
847: null, -- program_application_id
848: null, -- program_id
849: sysdate -- program_update_date
850: from dual
851: where NOT EXISTS
852: (select NULL
853: from bom_cto_src_orgs_b
854: where line_id = v_lines.line_id );

Line 1122: from dual;*/

1118: FOR v_bcolu_cfg IN c_bcolu_cfg LOOP
1119: --removed as part of bugfix 3340844
1120: /*select MTL_ITEM_REVISIONS_B_S.nextval
1121: into l_rev_id
1122: from dual;*/
1123:
1124:
1125: WriteToLog('Going to insert rows into mtl_item_revisions_b:: '|| v_bcolu_cfg.config_item_id,2);
1126: insert into mtl_item_revisions_b

Line 3216: DUAL_UOM_CONTROL,

3212: GLOBAL_ATTRIBUTE7,
3213: GLOBAL_ATTRIBUTE8,
3214: GLOBAL_ATTRIBUTE9,
3215: GLOBAL_ATTRIBUTE10,
3216: DUAL_UOM_CONTROL,
3217: DUAL_UOM_DEVIATION_HIGH,
3218: DUAL_UOM_DEVIATION_LOW,
3219: CONTRACT_ITEM_TYPE_CODE,
3220: SUBSCRIPTION_DEPEND_FLAG,

Line 3217: DUAL_UOM_DEVIATION_HIGH,

3213: GLOBAL_ATTRIBUTE8,
3214: GLOBAL_ATTRIBUTE9,
3215: GLOBAL_ATTRIBUTE10,
3216: DUAL_UOM_CONTROL,
3217: DUAL_UOM_DEVIATION_HIGH,
3218: DUAL_UOM_DEVIATION_LOW,
3219: CONTRACT_ITEM_TYPE_CODE,
3220: SUBSCRIPTION_DEPEND_FLAG,
3221: SERV_REQ_ENABLED_CODE,

Line 3218: DUAL_UOM_DEVIATION_LOW,

3214: GLOBAL_ATTRIBUTE9,
3215: GLOBAL_ATTRIBUTE10,
3216: DUAL_UOM_CONTROL,
3217: DUAL_UOM_DEVIATION_HIGH,
3218: DUAL_UOM_DEVIATION_LOW,
3219: CONTRACT_ITEM_TYPE_CODE,
3220: SUBSCRIPTION_DEPEND_FLAG,
3221: SERV_REQ_ENABLED_CODE,
3222: SERV_BILLING_ENABLED_FLAG,

Line 3543: m.DUAL_UOM_CONTROL,

3539: m.GLOBAL_ATTRIBUTE7,
3540: m.GLOBAL_ATTRIBUTE8,
3541: m.GLOBAL_ATTRIBUTE9,
3542: m.GLOBAL_ATTRIBUTE10,
3543: m.DUAL_UOM_CONTROL,
3544: m.DUAL_UOM_DEVIATION_HIGH,
3545: m.DUAL_UOM_DEVIATION_LOW,
3546: m.CONTRACT_ITEM_TYPE_CODE,
3547: m.SUBSCRIPTION_DEPEND_FLAG,

Line 3544: m.DUAL_UOM_DEVIATION_HIGH,

3540: m.GLOBAL_ATTRIBUTE8,
3541: m.GLOBAL_ATTRIBUTE9,
3542: m.GLOBAL_ATTRIBUTE10,
3543: m.DUAL_UOM_CONTROL,
3544: m.DUAL_UOM_DEVIATION_HIGH,
3545: m.DUAL_UOM_DEVIATION_LOW,
3546: m.CONTRACT_ITEM_TYPE_CODE,
3547: m.SUBSCRIPTION_DEPEND_FLAG,
3548: m.SERV_REQ_ENABLED_CODE,

Line 3545: m.DUAL_UOM_DEVIATION_LOW,

3541: m.GLOBAL_ATTRIBUTE9,
3542: m.GLOBAL_ATTRIBUTE10,
3543: m.DUAL_UOM_CONTROL,
3544: m.DUAL_UOM_DEVIATION_HIGH,
3545: m.DUAL_UOM_DEVIATION_LOW,
3546: m.CONTRACT_ITEM_TYPE_CODE,
3547: m.SUBSCRIPTION_DEPEND_FLAG,
3548: m.SERV_REQ_ENABLED_CODE,
3549: m.SERV_BILLING_ENABLED_FLAG,

Line 3960: DUAL_UOM_CONTROL,

3956: GLOBAL_ATTRIBUTE7,
3957: GLOBAL_ATTRIBUTE8,
3958: GLOBAL_ATTRIBUTE9,
3959: GLOBAL_ATTRIBUTE10,
3960: DUAL_UOM_CONTROL,
3961: DUAL_UOM_DEVIATION_HIGH,
3962: DUAL_UOM_DEVIATION_LOW,
3963: CONTRACT_ITEM_TYPE_CODE,
3964: SUBSCRIPTION_DEPEND_FLAG,

Line 3961: DUAL_UOM_DEVIATION_HIGH,

3957: GLOBAL_ATTRIBUTE8,
3958: GLOBAL_ATTRIBUTE9,
3959: GLOBAL_ATTRIBUTE10,
3960: DUAL_UOM_CONTROL,
3961: DUAL_UOM_DEVIATION_HIGH,
3962: DUAL_UOM_DEVIATION_LOW,
3963: CONTRACT_ITEM_TYPE_CODE,
3964: SUBSCRIPTION_DEPEND_FLAG,
3965: SERV_REQ_ENABLED_CODE,

Line 3962: DUAL_UOM_DEVIATION_LOW,

3958: GLOBAL_ATTRIBUTE9,
3959: GLOBAL_ATTRIBUTE10,
3960: DUAL_UOM_CONTROL,
3961: DUAL_UOM_DEVIATION_HIGH,
3962: DUAL_UOM_DEVIATION_LOW,
3963: CONTRACT_ITEM_TYPE_CODE,
3964: SUBSCRIPTION_DEPEND_FLAG,
3965: SERV_REQ_ENABLED_CODE,
3966: SERV_BILLING_ENABLED_FLAG,

Line 4287: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,

4283: m.GLOBAL_ATTRIBUTE7,
4284: m.GLOBAL_ATTRIBUTE8,
4285: m.GLOBAL_ATTRIBUTE9,
4286: m.GLOBAL_ATTRIBUTE10,
4287: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
4288: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
4289: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
4290: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
4291: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,

Line 4288: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,

4284: m.GLOBAL_ATTRIBUTE8,
4285: m.GLOBAL_ATTRIBUTE9,
4286: m.GLOBAL_ATTRIBUTE10,
4287: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
4288: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
4289: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
4290: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
4291: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,
4292: decode( get_attribute_control( 'serv_req_enabled_code' ) , 1, config.serv_req_enabled_code, m.SERV_REQ_ENABLED_CODE) ,

Line 4289: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,

4285: m.GLOBAL_ATTRIBUTE9,
4286: m.GLOBAL_ATTRIBUTE10,
4287: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
4288: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
4289: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
4290: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
4291: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,
4292: decode( get_attribute_control( 'serv_req_enabled_code' ) , 1, config.serv_req_enabled_code, m.SERV_REQ_ENABLED_CODE) ,
4293: decode( get_attribute_control( 'serv_billing_enabled_flag') , 1, config.serv_billing_enabled_flag, m.SERV_BILLING_ENABLED_FLAG) ,