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.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_SYSTEM_ITEMS

Line 39: FROM mtl_system_items

35:
36: l_eng_item_flag VARCHAR2(1) := NULL;
37: CURSOR eng_item_cur IS
38: SELECT eng_item_flag
39: FROM mtl_system_items
40: WHERE inventory_item_id = p_revised_item_id
41: AND organization_id = p_organization_id;
42:
43: BEGIN

Line 1269: FROM MTL_SYSTEM_ITEMS

1265: SELECT bom_item_type
1266: , pick_components_flag
1267: , bom_enabled_flag
1268: , eng_item_flag
1269: FROM MTL_SYSTEM_ITEMS
1270: WHERE ( bom_enabled_flag <> 'Y'
1271: OR pick_components_flag <> 'N'
1272: OR bom_item_type = l_PLANNING )
1273: AND organization_id = p_org_id

Line 1436: FROM MTL_SYSTEM_ITEMS

1432: , p_revised_item_id NUMBER)
1433: IS
1434: SELECT DECODE(restrict_subinventories_code, 1, 'Y', 'N') restrict_code
1435: , inventory_asset_flag
1436: FROM MTL_SYSTEM_ITEMS
1437: WHERE inventory_item_id = p_revised_item_id
1438: AND organization_id = p_organization_id ;
1439:
1440:

Line 1502: FROM mtl_system_items

1498:
1499: -- Get Value of Item Locator
1500: SELECT location_control_code
1501: INTO l_item_locator_control
1502: FROM mtl_system_items
1503: WHERE organization_id = p_organization_id
1504: AND inventory_item_id = p_revised_item_id;
1505:
1506: -- Get if locator is restricted or unrestricted

Line 1509: FROM mtl_system_items

1505:
1506: -- Get if locator is restricted or unrestricted
1507: SELECT RESTRICT_LOCATORS_CODE
1508: INTO l_item_loc_restricted
1509: FROM mtl_system_items
1510: WHERE organization_id = p_organization_id
1511: AND inventory_item_id = p_revised_item_id;
1512:
1513:

Line 2116: FROM mtl_system_items msi

2112:
2113: l_bom_enabled_flag VARCHAR2(1);
2114: CURSOR c_CheckBomEnabled IS
2115: SELECT bom_enabled_flag
2116: FROM mtl_system_items msi
2117: WHERE msi.inventory_item_id =
2118: p_rev_item_unexp_rec.revised_item_id
2119: AND msi.organization_id =
2120: p_rev_item_unexp_rec.organization_id;

Line 2134: FROM mtl_system_items

2130:
2131: l_product_family BOOLEAN := FALSE;
2132: CURSOR c_CheckItemProductFamily IS
2133: SELECT 'Product Family'
2134: FROM mtl_system_items
2135: WHERE inventory_item_id = p_rev_item_unexp_rec.revised_item_id
2136: AND organization_id = p_rev_item_unexp_rec.organization_id
2137: AND bom_item_type = 5; -- Product Family
2138:

Line 5315: FROM MTL_SYSTEM_ITEMS_B

5311: l_approval_status VARCHAR2(30);
5312:
5313: CURSOR c_approval_status IS
5314: SELECT nvl(approval_status,'A')
5315: FROM MTL_SYSTEM_ITEMS_B
5316: WHERE inventory_item_id = p_item_id
5317: AND organization_id = p_org_id;
5318: BEGIN
5319: OPEN c_approval_status;

Line 6133: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;

6129: --Start of changes Bug no:3034642
6130: l_profile_exist BOOLEAN;
6131: l_profile_val VARCHAR2(30);
6132: l_phase_change_code VARCHAR2(30) :='REVISE';
6133: l_catalog_category_id MTL_SYSTEM_ITEMS_B.ITEM_CATALOG_GROUP_ID%TYPE;
6134: l_Lifecycle_Id NUMBER;
6135: l_policy_code VARCHAR2(100);
6136: l_Old_Phase_Id mtl_item_revisions_b.current_phase_id%TYPE;
6137: l_Error_Code NUMBER;

Line 6146: select current_phase_id, LIFECYCLE_ID ,ITEM_CATALOG_GROUP_ID from mtl_system_items

6142: l_package_name varchar2(100) := 'EGO_LIFECYCLE_USER_PUB.get_policy_for_phase_change';
6143:
6144: CURSOR c_get_default_life(inv_id NUMBER,cp_org_id NUMBER)
6145: IS
6146: select current_phase_id, LIFECYCLE_ID ,ITEM_CATALOG_GROUP_ID from mtl_system_items
6147: where INVENTORY_ITEM_ID =inv_id and organization_id =cp_org_id;
6148:
6149: --End of changes Bug no:3034642
6150: BEGIN

Line 6419: FROM mtl_system_items

6415: AND trunc(scheduled_date) = trunc(p_effectivity_date);
6416:
6417: CURSOR c_RevItemType IS
6418: SELECT bom_item_type,eng_item_flag
6419: FROM mtl_system_items
6420: WHERE inventory_item_id = p_revised_item_id
6421: AND organization_id = p_organization_id;
6422:
6423: -- Moved from BOM_Validate_Op_Seq.Check_Access by MK on 12/04

Line 6911: FROM mtl_system_items_b

6907: ,x_item_lifecycle_Phase => l_current_phase_id
6908: ,x_item_catalogue_Group => l_item_catalog_group_id
6909: ,x_item_type => l_item_type);
6910: l_sql := 'SELECT COUNT(*)
6911: FROM mtl_system_items_b
6912: WHERE organization_id = :1
6913: AND inventory_item_status_code not in (''Inactive'', ''Obsolete'')
6914: AND inventory_item_id = :2';
6915: if l_current_phase_id IS NOT NULL then

Line 7016: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;

7012: EXC_ERR_PVT_API_MAIN EXCEPTION;
7013:
7014: -- init the following
7015: l_org_code VARCHAR2(3);
7016: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
7017: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
7018: l_from_item_revision mtl_item_revisions.revision%TYPE;
7019: l_completion_location_name VARCHAR2(1);
7020: l_from_work_order VARCHAR2(1);

Line 7017: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;

7013:
7014: -- init the following
7015: l_org_code VARCHAR2(3);
7016: l_revised_item_number mtl_system_items_vl.concatenated_segments%TYPE;
7017: l_use_up_item_name mtl_system_items_vl.concatenated_segments%TYPE;
7018: l_from_item_revision mtl_item_revisions.revision%TYPE;
7019: l_completion_location_name VARCHAR2(1);
7020: l_from_work_order VARCHAR2(1);
7021: l_to_work_order VARCHAR2(1);