APPS.EGO_ICC_STRUCTURE_PVT dependencies on DUAL

Line 64: from dual

60: /* We need to create structure header only for versioned ICCs which doesn't have structure header already. */
61:
62: select 1
63: into l_create_header
64: from dual
65: where exists (select 1
66: from EGO_MTL_CATALOG_GRP_VERS_B
67: where item_catalog_group_id = p_item_catalog_grp_id)
68: and not exists (select 1

Line 79: from dual;

75: for icc_structure in Get_str_catalog_hierarchy loop
76:
77: select bom_inventory_components_s.nextval
78: into l_bill_sequence_id
79: from dual;
80:
81: insert into BOM_STRUCTURES_B
82: (BILL_SEQUENCE_ID,
83: SOURCE_BILL_SEQUENCE_ID,

Line 205: from dual;

201: for component in get_version_components(l_bill_seq_id) loop
202:
203: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
204: into l_new_component_seq_id
205: from dual;
206:
207: Insert into BOM_COMPONENTS_B
208: (OPERATION_SEQ_NUM,
209: COMPONENT_ITEM_ID,

Line 641: from dual;

637: for cntr IN 1..v_struct_comp.COUNT LOOP
638:
639: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
640: into l_new_component_seq_id
641: from dual;
642:
643: Insert into BOM_COMPONENTS_B
644: (OPERATION_SEQ_NUM,
645: COMPONENT_ITEM_ID,

Line 1276: from dual

1272: and application_id = 702;
1273:
1274: select 1
1275: into l_updated
1276: from dual
1277: where exists(
1278: ((select
1279: ATTR_GROUP_ID,
1280: C_EXT_ATTR1,C_EXT_ATTR2,C_EXT_ATTR3,C_EXT_ATTR4,C_EXT_ATTR5,C_EXT_ATTR6,C_EXT_ATTR7,C_EXT_ATTR8,C_EXT_ATTR9,C_EXT_ATTR10,

Line 1357: from dual

1353: begin -- Added UT fix
1354:
1355: select 1
1356: into l_updated
1357: from dual
1358: where exists(
1359: ((select
1360: component_item_id,component_quantity,component_item_revision_id,
1361: component_remarks,change_notice,quantity_related,

Line 2050: from dual;

2046: l_item_seq_incr := l_item_seq_incr+to_number(l_item_seq_incr_prof);
2047:
2048: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
2049: into l_new_component_seq_id
2050: from dual;
2051: l_stmt_no := 340;
2052: Insert into BOM_COMPONENTS_B
2053: (OPERATION_SEQ_NUM,
2054: COMPONENT_ITEM_ID,

Line 2750: from dual;

2746: l_item_seq_incr := l_item_seq_incr + to_number(l_item_seq_incr_prof);
2747:
2748: select BOM_INVENTORY_COMPONENTS_S.NEXTVAL
2749: into l_new_component_seq_id
2750: from dual;
2751: l_stmt_no := 420;
2752: Insert into BOM_COMPONENTS_B
2753: (OPERATION_SEQ_NUM,
2754: COMPONENT_ITEM_ID,

Line 2969: from dual

2965: begin
2966:
2967: select 1
2968: into l_return_status
2969: from dual
2970: where exists (select 1
2971: from (select item_catalog_group_id
2972: from mtl_item_catalog_groups_b
2973: connect by prior parent_catalog_group_id = item_catalog_group_id

Line 3036: from dual

3032: /* We need to create structure header only for versioned ICCs which doesn't have structure header already. */
3033:
3034: select 1
3035: into l_create_header
3036: from dual
3037: where exists (select 1
3038: from EGO_MTL_CATALOG_GRP_VERS_B
3039: where item_catalog_group_id = p_item_catalog_grp_id)
3040: and not exists (select 1

Line 3051: from dual;

3047: for icc_structure in Get_str_catalog_hierarchy loop
3048:
3049: select bom_inventory_components_s.nextval
3050: into l_bill_sequence_id
3051: from dual;
3052:
3053: insert into BOM_STRUCTURES_B
3054: (BILL_SEQUENCE_ID,
3055: SOURCE_BILL_SEQUENCE_ID,

Line 3116: from dual

3112: Begin
3113:
3114: select 1
3115: into l_updatable
3116: from dual
3117: where not exists (select 1
3118: from BOM_STRUCTURES_B bsb,
3119: (select item_catalog_group_id
3120: from mtl_item_catalog_groups_b