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 1960: from dual;

1956:
1957: /* End Bugfix 2047428 */
1958: select bom_explosion_temp_s.nextval
1959: into xGrpId
1960: from dual;
1961:
1962: -- bugfix 1902818: Added nvl to oel.component_sequence_id.
1963: -- For ATO items, this will be null.
1964:

Line 2468: from dual;

2464: else
2465:
2466: select bom_explosion_temp_s.nextval
2467: into xGrpId
2468: from dual;
2469:
2470:
2471: lStmtNumber := 600;
2472: insert into bom_explosion_temp(

Line 2912: from dual;

2908:
2909: /* End Bugfix 2047428 */
2910: select bom_explosion_temp_s.nextval
2911: into lGroupid2
2912: from dual;
2913:
2914: select bom_explosion_temp_s.nextval
2915: into xGrpId
2916: from dual;

Line 2916: from dual;

2912: from dual;
2913:
2914: select bom_explosion_temp_s.nextval
2915: into xGrpId
2916: from dual;
2917:
2918: lStmtNumber := 600;
2919:
2920:

Line 3392: from dual;

3388:
3389: else
3390: select bom_explosion_temp_s.nextval
3391: into lGroupid2
3392: from dual;
3393:
3394: select bom_explosion_temp_s.nextval
3395: into xGrpId
3396: from dual;

Line 3396: from dual;

3392: from dual;
3393:
3394: select bom_explosion_temp_s.nextval
3395: into xGrpId
3396: from dual;
3397:
3398: lStmtNumber := 600;
3399:
3400:

Line 4444: from dual;

4440:
4441: if lNumberMethod = 1 then
4442: select mtl_system_items_B_S.nextval
4443: into lNextNum
4444: from dual;
4445:
4446: -- bugfix 1933740 : Replaced seg(1) with seg(app_col_ind)
4447:
4448: select ( substrb(seg(app_col_ind),1, decode(greatest(lFndSize,40),40,lFndSize -1-length(lNextNum),39 - length(lNextNum))) || lCiDel || to_char(lNextNum))

Line 4450: from dual;

4446: -- bugfix 1933740 : Replaced seg(1) with seg(app_col_ind)
4447:
4448: select ( substrb(seg(app_col_ind),1, decode(greatest(lFndSize,40),40,lFndSize -1-length(lNextNum),39 - length(lNextNum))) || lCiDel || to_char(lNextNum))
4449: into new_item_num
4450: from dual;
4451:
4452: elsif lNumberMethod = 2 then
4453: select to_char(mtl_system_items_B_S.nextval)
4454: into new_item_num

Line 4455: from dual;

4451:
4452: elsif lNumberMethod = 2 then
4453: select to_char(mtl_system_items_B_S.nextval)
4454: into new_item_num
4455: from dual;
4456:
4457: -- 2652379 : When numbering method is 3 , i.e Replace with order num, line num;
4458: -- item numbering segment ( Part num , item num , etc. ) is replaced with order
4459: -- number + line_number + shipment number. For model under model , item number gets

Line 4503: from dual;

4499: /*
4500: select decode(lDeliveryNum, NULL, lOrderNum || lCiDel || lLineNum,
4501: lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum )
4502: into new_item_num
4503: from dual;
4504: */
4505: select decode (lOptionNum, NULL, lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum,
4506: lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum || lCiDel || lOptionNum )
4507: into new_item_num

Line 4508: from dual;

4504: */
4505: select decode (lOptionNum, NULL, lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum,
4506: lOrderNum || lCiDel || lLineNum || lCiDel|| lDeliveryNum || lCiDel || lOptionNum )
4507: into new_item_num
4508: from dual;
4509: -- end fix 2652379
4510: else
4511: /*--------------------------+
4512: Call to user Defined Method

Line 4561: from dual;

4557: oe_debug_pub.add( 'Create_Item: '|| 'generating unique name' ,2 );
4558: END IF;
4559: select to_char(mtl_system_items_B_S.nextval)
4560: into lNextNum
4561: from dual;
4562: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4563: end if;
4564:
4565: /* bugfix 2706981: commented out and replaced with above check_dup_item

Line 4576: from dual;

4572: oe_debug_pub.add('Create_Item: ' || 'generating unique name' ,2 );
4573: END IF;
4574: select to_char(mtl_system_items_B_S.nextval)
4575: into lNextNum
4576: from dual;
4577: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4578: exit;
4579: end loop;
4580: */

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

4584:
4585: oe_debug_pub.add('Create_Item: ' || 'new_item number is ' || seg(app_col_ind) ,2 );
4586: END IF;
4587:
4588: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;
4589:
4590: IF PG_DEBUG <> 0 THEN
4591: oe_debug_pub.add('Create_Item: ' || 'new pConfigId is '||to_char(pConfigId),2);
4592: END IF;

Line 4970: DUAL_UOM_CONTROL,

4966: GLOBAL_ATTRIBUTE7,
4967: GLOBAL_ATTRIBUTE8,
4968: GLOBAL_ATTRIBUTE9,
4969: GLOBAL_ATTRIBUTE10,
4970: DUAL_UOM_CONTROL,
4971: DUAL_UOM_DEVIATION_HIGH,
4972: DUAL_UOM_DEVIATION_LOW,
4973: CONTRACT_ITEM_TYPE_CODE,
4974: SUBSCRIPTION_DEPEND_FLAG,

Line 4971: DUAL_UOM_DEVIATION_HIGH,

4967: GLOBAL_ATTRIBUTE8,
4968: GLOBAL_ATTRIBUTE9,
4969: GLOBAL_ATTRIBUTE10,
4970: DUAL_UOM_CONTROL,
4971: DUAL_UOM_DEVIATION_HIGH,
4972: DUAL_UOM_DEVIATION_LOW,
4973: CONTRACT_ITEM_TYPE_CODE,
4974: SUBSCRIPTION_DEPEND_FLAG,
4975: SERV_REQ_ENABLED_CODE,

Line 4972: DUAL_UOM_DEVIATION_LOW,

4968: GLOBAL_ATTRIBUTE9,
4969: GLOBAL_ATTRIBUTE10,
4970: DUAL_UOM_CONTROL,
4971: DUAL_UOM_DEVIATION_HIGH,
4972: DUAL_UOM_DEVIATION_LOW,
4973: CONTRACT_ITEM_TYPE_CODE,
4974: SUBSCRIPTION_DEPEND_FLAG,
4975: SERV_REQ_ENABLED_CODE,
4976: SERV_BILLING_ENABLED_FLAG,

Line 5320: m.DUAL_UOM_CONTROL,

5316: m.GLOBAL_ATTRIBUTE7,
5317: m.GLOBAL_ATTRIBUTE8,
5318: m.GLOBAL_ATTRIBUTE9,
5319: m.GLOBAL_ATTRIBUTE10,
5320: m.DUAL_UOM_CONTROL,
5321: m.DUAL_UOM_DEVIATION_HIGH,
5322: m.DUAL_UOM_DEVIATION_LOW,
5323: m.CONTRACT_ITEM_TYPE_CODE,
5324: m.SUBSCRIPTION_DEPEND_FLAG,

Line 5321: m.DUAL_UOM_DEVIATION_HIGH,

5317: m.GLOBAL_ATTRIBUTE8,
5318: m.GLOBAL_ATTRIBUTE9,
5319: m.GLOBAL_ATTRIBUTE10,
5320: m.DUAL_UOM_CONTROL,
5321: m.DUAL_UOM_DEVIATION_HIGH,
5322: m.DUAL_UOM_DEVIATION_LOW,
5323: m.CONTRACT_ITEM_TYPE_CODE,
5324: m.SUBSCRIPTION_DEPEND_FLAG,
5325: m.SERV_REQ_ENABLED_CODE,

Line 5322: m.DUAL_UOM_DEVIATION_LOW,

5318: m.GLOBAL_ATTRIBUTE9,
5319: m.GLOBAL_ATTRIBUTE10,
5320: m.DUAL_UOM_CONTROL,
5321: m.DUAL_UOM_DEVIATION_HIGH,
5322: m.DUAL_UOM_DEVIATION_LOW,
5323: m.CONTRACT_ITEM_TYPE_CODE,
5324: m.SUBSCRIPTION_DEPEND_FLAG,
5325: m.SERV_REQ_ENABLED_CODE,
5326: m.SERV_BILLING_ENABLED_FLAG,

Line 7306: From DUAL;

7302: END IF;
7303:
7304: Select cst_lists_s.nextval
7305: into l_cost_update
7306: From DUAL;
7307:
7308: lStmtNumber := 233;
7309:
7310: UPDATE CST_ITEM_COSTS

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

9264:
9265: IF PG_DEBUG <> 0 THEN --Bugfix 6063990
9266: oe_debug_pub.add('Inside populate_item_revision');
9267: END IF;
9268: --sql_stmt := 'SELECT MTL_ITEM_REVISIONS_B_S.nextval FROM dual';
9269:
9270: --IF PG_DEBUG <> 0 THEN
9271: -- oe_debug_pub.add(sql_stmt,3);
9272: --END IF;

Line 9766: DUAL_UOM_CONTROL,

9762: GLOBAL_ATTRIBUTE7,
9763: GLOBAL_ATTRIBUTE8,
9764: GLOBAL_ATTRIBUTE9,
9765: GLOBAL_ATTRIBUTE10,
9766: DUAL_UOM_CONTROL,
9767: DUAL_UOM_DEVIATION_HIGH,
9768: DUAL_UOM_DEVIATION_LOW,
9769: CONTRACT_ITEM_TYPE_CODE,
9770: SUBSCRIPTION_DEPEND_FLAG,

Line 9767: DUAL_UOM_DEVIATION_HIGH,

9763: GLOBAL_ATTRIBUTE8,
9764: GLOBAL_ATTRIBUTE9,
9765: GLOBAL_ATTRIBUTE10,
9766: DUAL_UOM_CONTROL,
9767: DUAL_UOM_DEVIATION_HIGH,
9768: DUAL_UOM_DEVIATION_LOW,
9769: CONTRACT_ITEM_TYPE_CODE,
9770: SUBSCRIPTION_DEPEND_FLAG,
9771: SERV_REQ_ENABLED_CODE,

Line 9768: DUAL_UOM_DEVIATION_LOW,

9764: GLOBAL_ATTRIBUTE9,
9765: GLOBAL_ATTRIBUTE10,
9766: DUAL_UOM_CONTROL,
9767: DUAL_UOM_DEVIATION_HIGH,
9768: DUAL_UOM_DEVIATION_LOW,
9769: CONTRACT_ITEM_TYPE_CODE,
9770: SUBSCRIPTION_DEPEND_FLAG,
9771: SERV_REQ_ENABLED_CODE,
9772: SERV_BILLING_ENABLED_FLAG,

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

10112: m.GLOBAL_ATTRIBUTE7,
10113: m.GLOBAL_ATTRIBUTE8,
10114: m.GLOBAL_ATTRIBUTE9,
10115: m.GLOBAL_ATTRIBUTE10,
10116: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
10117: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
10118: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
10119: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
10120: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,

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

10113: m.GLOBAL_ATTRIBUTE8,
10114: m.GLOBAL_ATTRIBUTE9,
10115: m.GLOBAL_ATTRIBUTE10,
10116: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
10117: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
10118: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
10119: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
10120: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,
10121: decode( get_attribute_control( 'serv_req_enabled_code' ) , 1, config.serv_req_enabled_code, m.SERV_REQ_ENABLED_CODE) ,

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

10114: m.GLOBAL_ATTRIBUTE9,
10115: m.GLOBAL_ATTRIBUTE10,
10116: decode( get_attribute_control( 'dual_uom_control') , 1, config.dual_uom_control, m.DUAL_UOM_CONTROL) ,
10117: decode( get_attribute_control( 'dual_uom_deviation_high') , 1, config.dual_uom_deviation_high, m.DUAL_UOM_DEVIATION_HIGH) ,
10118: decode( get_attribute_control( 'dual_uom_deviation_low') , 1, config.dual_uom_deviation_low, m.DUAL_UOM_DEVIATION_LOW) ,
10119: decode( get_attribute_control( 'contract_item_type_code') , 1, config.contract_item_type_code, m.CONTRACT_ITEM_TYPE_CODE) ,
10120: decode( get_attribute_control( 'subscription_depend_flag') , 1 , config.subscription_depend_flag, m.SUBSCRIPTION_DEPEND_FLAG) ,
10121: decode( get_attribute_control( 'serv_req_enabled_code' ) , 1, config.serv_req_enabled_code, m.SERV_REQ_ENABLED_CODE) ,
10122: decode( get_attribute_control( 'serv_billing_enabled_flag') , 1, config.serv_billing_enabled_flag, m.SERV_BILLING_ENABLED_FLAG) ,