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_SYSTEM_ITEMS

Line 731: /* from mtl_system_items msi

727: v_struct_comp(cntr).change_notice,
728: v_struct_comp(cntr).basis_type,
729: v_struct_comp(cntr).low_quantity,
730: v_struct_comp(cntr).high_quantity);
731: /* from mtl_system_items msi
732: where inventory_item_id = v_struct_comp(cntr).component_item_id
733: and organization_id = v_struct_comp(cntr).pk2_value; */
734:
735: l_src_pk_col_name_val_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'COMPONENT_SEQUENCE_ID' ,

Line 1435: from mtl_system_items_b

1431: l_catalog_group_id NUMBER;
1432: BEGIN
1433: select item_catalog_group_id
1434: INTO l_catalog_group_id
1435: from mtl_system_items_b
1436: where inventory_item_id = p_inventory_item_id
1437: and organization_id = p_organzation_id;
1438:
1439: RETURN l_catalog_group_id;

Line 1622: from mtl_system_items_kfv where inventory_item_id = comp.PK1_VALUE

1618: l_return_val := 1;
1619: begin
1620:
1621: select concatenated_segments into G_COMP_ITEM_NAME
1622: from mtl_system_items_kfv where inventory_item_id = comp.PK1_VALUE
1623: and organization_id = comp.pk2_value;
1624:
1625: /* UT Fix: Modified query to use ass_item_id instead of comp_item_id. */
1626: select revision_label into G_EFF_FROM

Line 1709: mtl_system_items_vl msiv

1705: and icc_structure.assembly_type = 2
1706: and icc_structure.effectivity_control = 4
1707: and icc_structure.bill_sequence_id = icc_str_components.bill_sequence_id
1708: and nvl(icc_str_components.parent_bill_seq_id,icc_str_components.bill_sequence_id) = icc_structure.bill_sequence_id) icc_str_comp,
1709: mtl_system_items_vl msiv
1710: where icc_str_comp.from_object_revision_id = EGO_ICC_STRUCTURE_PVT.Get_Effective_Version(icc_str_comp.pk1_value,p_rev_date)
1711: and msiv.inventory_item_id = icc_str_comp.component_item_id
1712: and msiv.organization_id = p_organization_id;
1713:

Line 1741: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;

1737: l_str_type EGO_COL_NAME_VALUE_PAIR_ARRAY;
1738: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
1739: l_data_level_id Number;
1740:
1741: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
1742: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
1743: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
1744: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
1745: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;

Line 1742: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;

1738: l_data_level_pks EGO_COL_NAME_VALUE_PAIR_ARRAY;
1739: l_data_level_id Number;
1740:
1741: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
1742: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
1743: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
1744: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
1745: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
1746: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;

Line 1743: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;

1739: l_data_level_id Number;
1740:
1741: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
1742: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
1743: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
1744: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
1745: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
1746: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;
1747:

Line 1744: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;

1740:
1741: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
1742: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
1743: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
1744: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
1745: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
1746: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;
1747:
1748: l_Return_Status Varchar2(1) := 'S';

Line 1745: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;

1741: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
1742: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
1743: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
1744: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
1745: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
1746: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;
1747:
1748: l_Return_Status Varchar2(1) := 'S';
1749:

Line 1746: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;

1742: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
1743: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
1744: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
1745: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
1746: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;
1747:
1748: l_Return_Status Varchar2(1) := 'S';
1749:
1750: l_item_seq_incr_prof VARCHAR2(10) := nvl(fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT'),10);

Line 1821: from MTL_SYSTEM_ITEMS_VL

1817: l_stmt_no := 70;
1818: select bom_item_type,eam_item_type,base_item_id,replenish_to_order_flag,pick_components_flag,atp_components_flag
1819: into l_assy_bom_item_type,l_assy_eam_item_type,l_assy_base_item_id,l_assy_replenish_to_order_flag,l_assy_pick_components_flag,
1820: l_assy_atp_comp_flag
1821: from MTL_SYSTEM_ITEMS_VL
1822: where inventory_item_id = p_inventory_item_id
1823: and organization_id = p_organization_id;
1824: l_stmt_no := 80;
1825: select concatenated_segments into G_ASSY_ITEM_NAME

Line 1826: from mtl_system_items_kfv where inventory_item_id = p_inventory_item_id and organization_id = p_organization_id;

1822: where inventory_item_id = p_inventory_item_id
1823: and organization_id = p_organization_id;
1824: l_stmt_no := 80;
1825: select concatenated_segments into G_ASSY_ITEM_NAME
1826: from mtl_system_items_kfv where inventory_item_id = p_inventory_item_id and organization_id = p_organization_id;
1827: l_stmt_no := 90;
1828: populate_item_rev_details(p_inventory_item_id,p_organization_id);
1829: l_stmt_no := 100;
1830: l_ins_cntr := 0;

Line 1852: from mtl_system_items_kfv where inventory_item_id = component.component_item_id

1848: --Return;
1849: End If;
1850: l_stmt_no := 140;
1851: select concatenated_segments into G_COMP_ITEM_NAME
1852: from mtl_system_items_kfv where inventory_item_id = component.component_item_id
1853: and organization_id = p_organization_id;
1854: l_stmt_no := 150;
1855: if v_icc_comp_tbl.exists(component.component_item_id) then
1856: x_Return_Status := 1;

Line 2256: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;

2252: l_errorcode Number;
2253: l_msg_count Number;
2254: l_msg_data Varchar2(2000);
2255:
2256: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
2257: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
2258: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
2259: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
2260: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;

Line 2257: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;

2253: l_msg_count Number;
2254: l_msg_data Varchar2(2000);
2255:
2256: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
2257: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
2258: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
2259: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
2260: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
2261: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;

Line 2258: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;

2254: l_msg_data Varchar2(2000);
2255:
2256: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
2257: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
2258: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
2259: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
2260: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
2261: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;
2262:

Line 2259: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;

2255:
2256: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
2257: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
2258: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
2259: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
2260: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
2261: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;
2262:
2263: cursor item_structure(p_inventory_item_id Number,

Line 2260: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;

2256: l_assy_bom_item_type MTL_SYSTEM_ITEMS_VL.bom_item_type%type;
2257: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
2258: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
2259: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
2260: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
2261: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;
2262:
2263: cursor item_structure(p_inventory_item_id Number,
2264: p_organization_id Number) is

Line 2261: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;

2257: l_assy_eam_item_type MTL_SYSTEM_ITEMS_VL.eam_item_type%type;
2258: l_assy_base_item_id MTL_SYSTEM_ITEMS_VL.base_item_id%type;
2259: l_assy_replenish_to_order_flag MTL_SYSTEM_ITEMS_VL.replenish_to_order_flag%type;
2260: l_assy_pick_components_flag MTL_SYSTEM_ITEMS_VL.pick_components_flag%type;
2261: l_assy_atp_comp_flag MTL_SYSTEM_ITEMS_VL.atp_components_flag%type;
2262:
2263: cursor item_structure(p_inventory_item_id Number,
2264: p_organization_id Number) is
2265: select structure_type_id,alternate_bom_designator,bill_sequence_id

Line 2311: mtl_system_items_vl msiv

2307: and icc_structure.assembly_type = 2
2308: and icc_structure.effectivity_control = 4
2309: and icc_structure.bill_sequence_id = icc_str_components.bill_sequence_id
2310: and nvl(icc_str_components.parent_bill_seq_id,icc_str_components.bill_sequence_id) = icc_structure.bill_sequence_id) icc_str_comp,
2311: mtl_system_items_vl msiv
2312: where icc_str_comp.from_object_revision_id = EGO_ICC_STRUCTURE_PVT.Get_Effective_Version(icc_str_comp.pk1_value,p_rev_date)
2313: and msiv.inventory_item_id = icc_str_comp.component_item_id
2314: and msiv.organization_id = p_organization_id;
2315:

Line 2431: from MTL_SYSTEM_ITEMS_VL

2427: l_stmt_no := 70;
2428: select bom_item_type,eam_item_type,base_item_id,replenish_to_order_flag,pick_components_flag,atp_components_flag
2429: into l_assy_bom_item_type,l_assy_eam_item_type,l_assy_base_item_id,l_assy_replenish_to_order_flag,l_assy_pick_components_flag,
2430: l_assy_atp_comp_flag
2431: from MTL_SYSTEM_ITEMS_VL
2432: where inventory_item_id = p_inventory_item_id
2433: and organization_id = p_organization_id;
2434:
2435: l_stmt_no := 80;

Line 2437: from mtl_system_items_kfv where inventory_item_id = p_inventory_item_id and organization_id = p_organization_id;

2433: and organization_id = p_organization_id;
2434:
2435: l_stmt_no := 80;
2436: select concatenated_segments into G_ASSY_ITEM_NAME
2437: from mtl_system_items_kfv where inventory_item_id = p_inventory_item_id and organization_id = p_organization_id;
2438: l_stmt_no := 90;
2439: populate_item_rev_details(p_inventory_item_id,p_organization_id);
2440: l_stmt_no := 100;
2441: if v_item_revisions_tbl.exists(v_rev_index(p_revision_id)-1) then

Line 2462: from mtl_system_items_kfv where inventory_item_id = component.component_item_id

2458: --Return;
2459: End If;
2460: l_stmt_no := 130;
2461: select concatenated_segments into G_COMP_ITEM_NAME
2462: from mtl_system_items_kfv where inventory_item_id = component.component_item_id
2463: and organization_id = p_organization_id;
2464: l_stmt_no := 140;
2465: if v_icc_comp_tbl.exists(component.component_item_id) then
2466: x_Return_Status := 1;

Line 3211: from mtl_system_items

3207: if p_enforce_int_requirements = 1 then
3208: BEGIN
3209: select 1
3210: into l_dummy
3211: from mtl_system_items
3212: where inventory_item_id = p_component_item_id
3213: and organization_id = p_organization_id
3214: and rounding_control_type = 1;
3215: EXCEPTION

Line 3320: FROM mtl_system_items

3316: SELECT stock_locator_control_code INTO l_org_locator_control
3317: FROM mtl_parameters WHERE organization_id = p_organization_id;
3318:
3319: SELECT location_control_code INTO l_item_locator_control
3320: FROM mtl_system_items
3321: WHERE organization_id = p_organization_id AND inventory_item_id = p_component_item_id;
3322:
3323: SELECT LOCATOR_TYPE into l_sub_locator_control
3324: FROM MTL_SECONDARY_INVENTORIES