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.ENGECOBO dependencies on MTL_SYSTEM_ITEMS_VL

Line 3452: l_component_item_name mtl_system_items_vl.concatenated_segments%type;

3448: l_rev_component_count NUMBER := 1;
3449: l_sub_component_count NUMBER := 1;
3450: l_ref_designator_count NUMBER := 1;
3451:
3452: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3453: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3456: l_new_item_revision VARCHAR2(3);

Line 3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;

3450: l_ref_designator_count NUMBER := 1;
3451:
3452: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3453: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3456: l_new_item_revision VARCHAR2(3);
3457: l_effectivity_date DATE;
3458: st_number NUMBER;

Line 3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;

3451:
3452: l_component_item_name mtl_system_items_vl.concatenated_segments%type;
3453: l_location_name mtl_item_locations_kfv.concatenated_segments%type;
3454: l_substitute_component_name mtl_system_items_vl.concatenated_segments%type;
3455: l_revised_item_name mtl_system_items_vl.concatenated_segments%type;
3456: l_new_item_revision VARCHAR2(3);
3457: l_effectivity_date DATE;
3458: st_number NUMBER;
3459: item_id NUMBER;

Line 4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4864: l_sourcing_rules_exists NUMBER;
4865: --l_propagated_rev_items_tbl Prop_Rev_Items_Tbl_Type;
4866: --l_prop_rev_items_count NUMBER;
4867: l_propagate_revised_item NUMBER;
4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

Line 4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;

4866: --l_prop_rev_items_count NUMBER;
4867: l_propagate_revised_item NUMBER;
4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
4874: l_new_struc_revision VARCHAR2(3);

Line 4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4867: l_propagate_revised_item NUMBER;
4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
4874: l_new_struc_revision VARCHAR2(3);
4875: l_current_struc_revision VARCHAR2(3);

Line 4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4868: l_parent_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4869: l_use_up_plan_name mrp_bom_plan_name_lov_v.plan_name%TYPE;
4870: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
4871: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
4874: l_new_struc_revision VARCHAR2(3);
4875: l_current_struc_revision VARCHAR2(3);
4876: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;

Line 4876: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;

4872: l_revised_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4873: l_new_item_revision mtl_item_revisions.revision%TYPE;
4874: l_new_struc_revision VARCHAR2(3);
4875: l_current_struc_revision VARCHAR2(3);
4876: l_from_end_item_name mtl_system_items_vl.concatenated_segments%TYPE;
4877: l_from_end_item_alternate VARCHAR2(10);
4878: l_from_end_item_revision mtl_item_revisions.revision%TYPE;
4879: l_current_local_revision_id NUMBER;
4880: l_current_local_revision VARCHAR2(3);

Line 5239: || 'FROM pa_ego_phases_v LP, MTL_System_items_vl msiv '

5235: BEGIN
5236: -- Bug 3311072: Made the query dynamic
5237: -- Modified By LKASTURI
5238: l_sql_stmt := 'SELECT LP.DISPLAY_SEQUENCE, LP.NAME '
5239: || 'FROM pa_ego_phases_v LP, MTL_System_items_vl msiv '
5240: || 'WHERE LP.PROJ_ELEMENT_ID = msiv.CURRENT_PHASE_ID '
5241: || 'AND msiv.INVENTORY_ITEM_ID = :1 '
5242: || 'AND msiv.ORGANIZATION_ID = :2 ';
5243: -- End Changes 3311072