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

Line 1867: from dual;

1863:
1864: /* End Bugfix 2047428 */
1865: select bom_explosion_temp_s.nextval
1866: into xGrpId
1867: from dual;
1868:
1869: -- bugfix 1902818: Added nvl to oel.component_sequence_id.
1870: -- For ATO items, this will be null.
1871:

Line 2375: from dual;

2371: else
2372:
2373: select bom_explosion_temp_s.nextval
2374: into xGrpId
2375: from dual;
2376:
2377:
2378: lStmtNumber := 600;
2379: insert into bom_explosion_temp(

Line 2819: from dual;

2815:
2816: /* End Bugfix 2047428 */
2817: select bom_explosion_temp_s.nextval
2818: into lGroupid2
2819: from dual;
2820:
2821: select bom_explosion_temp_s.nextval
2822: into xGrpId
2823: from dual;

Line 2823: from dual;

2819: from dual;
2820:
2821: select bom_explosion_temp_s.nextval
2822: into xGrpId
2823: from dual;
2824:
2825: lStmtNumber := 600;
2826:
2827:

Line 3299: from dual;

3295:
3296: else
3297: select bom_explosion_temp_s.nextval
3298: into lGroupid2
3299: from dual;
3300:
3301: select bom_explosion_temp_s.nextval
3302: into xGrpId
3303: from dual;

Line 3303: from dual;

3299: from dual;
3300:
3301: select bom_explosion_temp_s.nextval
3302: into xGrpId
3303: from dual;
3304:
3305: lStmtNumber := 600;
3306:
3307:

Line 4349: from dual;

4345:
4346: if lNumberMethod = 1 then
4347: select mtl_system_items_B_S.nextval
4348: into lNextNum
4349: from dual;
4350:
4351: -- bugfix 1933740 : Replaced seg(1) with seg(app_col_ind)
4352:
4353: select ( substrb(seg(app_col_ind),1, decode(greatest(lFndSize,40),40,lFndSize -1-length(lNextNum),39 - length(lNextNum))) || lCiDel || to_char(lNextNum))

Line 4355: from dual;

4351: -- bugfix 1933740 : Replaced seg(1) with seg(app_col_ind)
4352:
4353: select ( substrb(seg(app_col_ind),1, decode(greatest(lFndSize,40),40,lFndSize -1-length(lNextNum),39 - length(lNextNum))) || lCiDel || to_char(lNextNum))
4354: into new_item_num
4355: from dual;
4356:
4357: elsif lNumberMethod = 2 then
4358: select to_char(mtl_system_items_B_S.nextval)
4359: into new_item_num

Line 4360: from dual;

4356:
4357: elsif lNumberMethod = 2 then
4358: select to_char(mtl_system_items_B_S.nextval)
4359: into new_item_num
4360: from dual;
4361:
4362: -- 2652379 : When numbering method is 3 , i.e Replace with order num, line num;
4363: -- item numbering segment ( Part num , item num , etc. ) is replaced with order
4364: -- number + line_number + shipment number. For model under model , item number gets

Line 4408: from dual;

4404: /*
4405: select decode(lDeliveryNum, NULL, lOrderNum || lCiDel || lLineNum,
4406: lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum )
4407: into new_item_num
4408: from dual;
4409: */
4410: select decode (lOptionNum, NULL, lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum,
4411: lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum || lCiDel || lOptionNum )
4412: into new_item_num

Line 4413: from dual;

4409: */
4410: select decode (lOptionNum, NULL, lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum,
4411: lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum || lCiDel || lOptionNum )
4412: into new_item_num
4413: from dual;
4414: -- end fix 2652379
4415: else
4416: /*--------------------------+
4417: Call to user Defined Method

Line 4466: from dual;

4462: oe_debug_pub.add( 'Create_Item: '|| 'generating unique name' ,2 );
4463: END IF;
4464: select to_char(mtl_system_items_B_S.nextval)
4465: into lNextNum
4466: from dual;
4467: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4468: end if;
4469:
4470: /* bugfix 2706981: commented out and replaced with above check_dup_item

Line 4481: from dual;

4477: oe_debug_pub.add('Create_Item: ' || 'generating unique name' ,2 );
4478: END IF;
4479: select to_char(mtl_system_items_B_S.nextval)
4480: into lNextNum
4481: from dual;
4482: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4483: exit;
4484: end loop;
4485: */

Line 4493: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;

4489:
4490: oe_debug_pub.add('Create_Item: ' || 'new_item number is ' || seg(app_col_ind) ,2 );
4491: END IF;
4492:
4493: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;
4494:
4495: IF PG_DEBUG <> 0 THEN
4496: oe_debug_pub.add('Create_Item: ' || 'new pConfigId is '||to_char(pConfigId),2);
4497: END IF;

Line 4857: DUAL_UOM_CONTROL,

4853: GLOBAL_ATTRIBUTE7,
4854: GLOBAL_ATTRIBUTE8,
4855: GLOBAL_ATTRIBUTE9,
4856: GLOBAL_ATTRIBUTE10,
4857: DUAL_UOM_CONTROL,
4858: DUAL_UOM_DEVIATION_HIGH,
4859: DUAL_UOM_DEVIATION_LOW,
4860: CONTRACT_ITEM_TYPE_CODE,
4861: SUBSCRIPTION_DEPEND_FLAG,

Line 4858: DUAL_UOM_DEVIATION_HIGH,

4854: GLOBAL_ATTRIBUTE8,
4855: GLOBAL_ATTRIBUTE9,
4856: GLOBAL_ATTRIBUTE10,
4857: DUAL_UOM_CONTROL,
4858: DUAL_UOM_DEVIATION_HIGH,
4859: DUAL_UOM_DEVIATION_LOW,
4860: CONTRACT_ITEM_TYPE_CODE,
4861: SUBSCRIPTION_DEPEND_FLAG,
4862: SERV_REQ_ENABLED_CODE,

Line 4859: DUAL_UOM_DEVIATION_LOW,

4855: GLOBAL_ATTRIBUTE9,
4856: GLOBAL_ATTRIBUTE10,
4857: DUAL_UOM_CONTROL,
4858: DUAL_UOM_DEVIATION_HIGH,
4859: DUAL_UOM_DEVIATION_LOW,
4860: CONTRACT_ITEM_TYPE_CODE,
4861: SUBSCRIPTION_DEPEND_FLAG,
4862: SERV_REQ_ENABLED_CODE,
4863: SERV_BILLING_ENABLED_FLAG,

Line 5190: m.DUAL_UOM_CONTROL,

5186: m.GLOBAL_ATTRIBUTE7,
5187: m.GLOBAL_ATTRIBUTE8,
5188: m.GLOBAL_ATTRIBUTE9,
5189: m.GLOBAL_ATTRIBUTE10,
5190: m.DUAL_UOM_CONTROL,
5191: m.DUAL_UOM_DEVIATION_HIGH,
5192: m.DUAL_UOM_DEVIATION_LOW,
5193: m.CONTRACT_ITEM_TYPE_CODE,
5194: m.SUBSCRIPTION_DEPEND_FLAG,

Line 5191: m.DUAL_UOM_DEVIATION_HIGH,

5187: m.GLOBAL_ATTRIBUTE8,
5188: m.GLOBAL_ATTRIBUTE9,
5189: m.GLOBAL_ATTRIBUTE10,
5190: m.DUAL_UOM_CONTROL,
5191: m.DUAL_UOM_DEVIATION_HIGH,
5192: m.DUAL_UOM_DEVIATION_LOW,
5193: m.CONTRACT_ITEM_TYPE_CODE,
5194: m.SUBSCRIPTION_DEPEND_FLAG,
5195: m.SERV_REQ_ENABLED_CODE,

Line 5192: m.DUAL_UOM_DEVIATION_LOW,

5188: m.GLOBAL_ATTRIBUTE9,
5189: m.GLOBAL_ATTRIBUTE10,
5190: m.DUAL_UOM_CONTROL,
5191: m.DUAL_UOM_DEVIATION_HIGH,
5192: m.DUAL_UOM_DEVIATION_LOW,
5193: m.CONTRACT_ITEM_TYPE_CODE,
5194: m.SUBSCRIPTION_DEPEND_FLAG,
5195: m.SERV_REQ_ENABLED_CODE,
5196: m.SERV_BILLING_ENABLED_FLAG,

Line 7121: From DUAL;

7117: END IF;
7118:
7119: Select cst_lists_s.nextval
7120: into l_cost_update
7121: From DUAL;
7122:
7123: lStmtNumber := 233;
7124:
7125: UPDATE CST_ITEM_COSTS

Line 8967: --sql_stmt := 'SELECT MTL_ITEM_REVISIONS_B_S.nextval FROM dual';

8963:
8964: IF PG_DEBUG <> 0 THEN --Bugfix 6063990
8965: oe_debug_pub.add('Inside populate_item_revision');
8966: END IF;
8967: --sql_stmt := 'SELECT MTL_ITEM_REVISIONS_B_S.nextval FROM dual';
8968:
8969: --IF PG_DEBUG <> 0 THEN
8970: -- oe_debug_pub.add(sql_stmt,3);
8971: --END IF;

Line 9448: DUAL_UOM_CONTROL,

9444: GLOBAL_ATTRIBUTE7,
9445: GLOBAL_ATTRIBUTE8,
9446: GLOBAL_ATTRIBUTE9,
9447: GLOBAL_ATTRIBUTE10,
9448: DUAL_UOM_CONTROL,
9449: DUAL_UOM_DEVIATION_HIGH,
9450: DUAL_UOM_DEVIATION_LOW,
9451: CONTRACT_ITEM_TYPE_CODE,
9452: SUBSCRIPTION_DEPEND_FLAG,

Line 9449: DUAL_UOM_DEVIATION_HIGH,

9445: GLOBAL_ATTRIBUTE8,
9446: GLOBAL_ATTRIBUTE9,
9447: GLOBAL_ATTRIBUTE10,
9448: DUAL_UOM_CONTROL,
9449: DUAL_UOM_DEVIATION_HIGH,
9450: DUAL_UOM_DEVIATION_LOW,
9451: CONTRACT_ITEM_TYPE_CODE,
9452: SUBSCRIPTION_DEPEND_FLAG,
9453: SERV_REQ_ENABLED_CODE,

Line 9450: DUAL_UOM_DEVIATION_LOW,

9446: GLOBAL_ATTRIBUTE9,
9447: GLOBAL_ATTRIBUTE10,
9448: DUAL_UOM_CONTROL,
9449: DUAL_UOM_DEVIATION_HIGH,
9450: DUAL_UOM_DEVIATION_LOW,
9451: CONTRACT_ITEM_TYPE_CODE,
9452: SUBSCRIPTION_DEPEND_FLAG,
9453: SERV_REQ_ENABLED_CODE,
9454: SERV_BILLING_ENABLED_FLAG,

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

9777: m.GLOBAL_ATTRIBUTE7,
9778: m.GLOBAL_ATTRIBUTE8,
9779: m.GLOBAL_ATTRIBUTE9,
9780: m.GLOBAL_ATTRIBUTE10,
9781: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
9782: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
9783: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
9784: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
9785: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,

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

9778: m.GLOBAL_ATTRIBUTE8,
9779: m.GLOBAL_ATTRIBUTE9,
9780: m.GLOBAL_ATTRIBUTE10,
9781: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
9782: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
9783: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
9784: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
9785: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,
9786: decode( get_attribute_control( 'serv_req_enabled_code' ) , 1, config.serv_req_enabled_code, m.SERV_REQ_ENABLED_CODE) ,

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

9779: m.GLOBAL_ATTRIBUTE9,
9780: m.GLOBAL_ATTRIBUTE10,
9781: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
9782: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
9783: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
9784: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
9785: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,
9786: decode( get_attribute_control( 'serv_req_enabled_code' ) , 1, config.serv_req_enabled_code, m.SERV_REQ_ENABLED_CODE) ,
9787: decode( get_attribute_control( 'serv_billing_enabled_flag') , 1, config.serv_billing_enabled_flag, m.SERV_BILLING_ENABLED_FLAG) ,