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_VL

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 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;