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.EGO_ICC_STRUCTURE_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 50: from mtl_item_catalog_groups_b

46: cursor Get_str_catalog_hierarchy
47: IS
48: select structures.bill_sequence_id
49: from ( select item_catalog_group_id
50: from mtl_item_catalog_groups_b
51: connect by prior parent_catalog_group_id = item_catalog_group_id
52: start with item_catalog_group_id = p_item_catalog_grp_id ) icc,
53: BOM_STRUCTURES_B structures
54: where structures.pk1_value = icc.item_catalog_group_id

Line 401: from mtl_item_catalog_groups_b

397:
398: Cursor parent_catalog is
399: select item_catalog_group_id,
400: parent_catalog_group_id
401: from mtl_item_catalog_groups_b
402: connect by prior parent_catalog_group_id = item_catalog_group_id
403: start with item_catalog_group_id = p_item_catalog_grp_id;
404:
405: type rec_component IS record(

Line 797: from MTL_ITEM_CATALOG_GROUPS_B_KFV

793:
794: if p_parent_bill_seq_id is null then
795: select concatenated_segments
796: into l_item_catalog_grp_name
797: from MTL_ITEM_CATALOG_GROUPS_B_KFV
798: where item_catalog_group_id = p_item_catalog_grp_id;
799: else
800: select pk1_value
801: into l_item_catalog_grp_id

Line 808: from MTL_ITEM_CATALOG_GROUPS_B_KFV

804: and obj_name= 'EGO_CATALOG_GROUP';
805:
806: select concatenated_segments
807: into l_item_catalog_grp_name
808: from MTL_ITEM_CATALOG_GROUPS_B_KFV
809: where item_catalog_group_id = l_item_catalog_grp_id;
810: end if;
811:
812: return l_item_catalog_grp_name;

Line 852: FROM MTL_ITEM_CATALOG_GROUPS_B

848: l_parent_catalog_grp_id NUMBER;
849: BEGIN
850: SELECT parent_catalog_group_id
851: into l_parent_catalog_grp_id
852: FROM MTL_ITEM_CATALOG_GROUPS_B
853: WHERE item_catalog_group_id = p_item_catalog_grp_id;
854:
855: if l_parent_catalog_grp_id is not null then
856: l_effective_version := Get_Effective_Version(l_parent_catalog_grp_id,p_start_date);

Line 955: from mtl_item_catalog_groups_b

951: Cursor parent_catalog
952: is
953: select item_catalog_group_id,
954: parent_catalog_group_id
955: from mtl_item_catalog_groups_b
956: connect by prior parent_catalog_group_id = item_catalog_group_id
957: start with item_catalog_group_id = p_item_catalog_grp_id;
958:
959: type rec_component IS record(

Line 1695: from mtl_item_catalog_groups_b

1691: icc_str_components.component_quantity,
1692: icc_str_components.required_to_ship,
1693: icc_str_components.required_for_revenue
1694: from (select item_catalog_group_id
1695: from mtl_item_catalog_groups_b
1696: connect by prior parent_catalog_group_id = item_catalog_group_id
1697: start with item_catalog_group_id = p_item_catalog_grp_id) icc,
1698: bom_structures_b icc_structure,
1699: bom_components_b icc_str_components

Line 1796: from mtl_item_catalog_groups_b

1792: select null
1793: into l_catalog_bill_sequence_id
1794: from bom_structures_b
1795: where pk1_value in (select item_catalog_group_id
1796: from mtl_item_catalog_groups_b
1797: connect by prior parent_catalog_group_id = item_catalog_group_id
1798: start with item_catalog_group_id = l_catalog_group_id)
1799: and pk2_value = to_char(p_organization_id)
1800: and obj_name = 'EGO_CATALOG_GROUP'

Line 2297: from mtl_item_catalog_groups_b

2293: icc_str_components.component_quantity,
2294: icc_str_components.required_to_ship,
2295: icc_str_components.required_for_revenue
2296: from (select item_catalog_group_id
2297: from mtl_item_catalog_groups_b
2298: connect by prior parent_catalog_group_id = item_catalog_group_id
2299: start with item_catalog_group_id = p_item_catalog_grp_id) icc,
2300: bom_structures_b icc_structure,
2301: bom_components_b icc_str_components

Line 2394: from mtl_item_catalog_groups_b

2390: select structure_type_id,alternate_bom_designator
2391: into l_catalog_str_type_id,G_ALTCODE
2392: from bom_structures_b
2393: where pk1_value in (select item_catalog_group_id
2394: from mtl_item_catalog_groups_b
2395: connect by prior parent_catalog_group_id = item_catalog_group_id
2396: start with item_catalog_group_id = l_catalog_group_id)
2397: and pk2_value = to_char(p_organization_id)
2398: and obj_name = 'EGO_CATALOG_GROUP'

Line 2972: from mtl_item_catalog_groups_b

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
2974: start with item_catalog_group_id = p_item_catalog_grp_id) icc,
2975: bom_structures_b icc_structure,
2976: bom_components_b icc_str_components

Line 3022: from mtl_item_catalog_groups_b

3018: cursor Get_str_catalog_hierarchy
3019: IS
3020: select structures.bill_sequence_id
3021: from ( select item_catalog_group_id
3022: from mtl_item_catalog_groups_b
3023: connect by prior parent_catalog_group_id = item_catalog_group_id
3024: start with item_catalog_group_id = p_item_catalog_grp_id ) icc,
3025: BOM_STRUCTURES_B structures
3026: where structures.pk1_value = icc.item_catalog_group_id

Line 3120: from mtl_item_catalog_groups_b

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
3121: connect by prior item_catalog_group_id = parent_catalog_group_id
3122: start with item_catalog_group_id = p_item_catalog_grp_id ) child_icc
3123: where bsb.pk1_value = child_icc.item_catalog_group_id
3124: and bsb.obj_name = 'EGO_CATALOG_GROUP'