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

Line 140: l_parent_item_type MTL_SYSTEM_ITEMS.ITEM_TYPE%TYPE;

136: , p_organization_id IN NUMBER
137: )
138: IS
139: l_customization_code AK_CUSTOMIZATIONS.CUSTOMIZATION_CODE%TYPE;
140: l_parent_item_type MTL_SYSTEM_ITEMS.ITEM_TYPE%TYPE;
141: l_child_item_type MTL_SYSTEM_ITEMS.ITEM_TYPE%TYPE;
142: l_parent_item_type_name FND_LOOKUP_VALUES_VL.MEANING%TYPE;
143: l_child_item_type_name FND_LOOKUP_VALUES_VL.MEANING%TYPE;
144: l_return_status VARCHAR2(1);

Line 141: l_child_item_type MTL_SYSTEM_ITEMS.ITEM_TYPE%TYPE;

137: )
138: IS
139: l_customization_code AK_CUSTOMIZATIONS.CUSTOMIZATION_CODE%TYPE;
140: l_parent_item_type MTL_SYSTEM_ITEMS.ITEM_TYPE%TYPE;
141: l_child_item_type MTL_SYSTEM_ITEMS.ITEM_TYPE%TYPE;
142: l_parent_item_type_name FND_LOOKUP_VALUES_VL.MEANING%TYPE;
143: l_child_item_type_name FND_LOOKUP_VALUES_VL.MEANING%TYPE;
144: l_return_status VARCHAR2(1);
145: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 168: FROM MTL_SYSTEM_ITEMS_KFV MSI ,FND_COMMON_LOOKUPS LOOKUP

164: l_return_status := 'N';
165:
166: SELECT MSI.ITEM_TYPE, LOOKUP.MEANING ,MSI.CONCATENATED_SEGMENTS
167: INTO l_parent_item_type,l_parent_item_type_name,l_parent_name
168: FROM MTL_SYSTEM_ITEMS_KFV MSI ,FND_COMMON_LOOKUPS LOOKUP
169: WHERE
170: INVENTORY_ITEM_ID = p_parent_item_id AND ORGANIZATION_ID = p_organization_id
171: AND MSI.ITEM_TYPE = LOOKUP.LOOKUP_CODE(+)
172: AND LOOKUP.LOOKUP_TYPE(+) = 'ITEM_TYPE'

Line 183: FROM MTL_SYSTEM_ITEMS_KFV MSI ,FND_COMMON_LOOKUPS LOOKUP

179: --dbms_output.put_line('l_parent_item_type '||l_parent_item_type);
180:
181: SELECT MSI.ITEM_TYPE, LOOKUP.MEANING ,MSI.CONCATENATED_SEGMENTS
182: INTO l_child_item_type , l_child_item_type_name,l_child_name
183: FROM MTL_SYSTEM_ITEMS_KFV MSI ,FND_COMMON_LOOKUPS LOOKUP
184: WHERE
185: INVENTORY_ITEM_ID = p_child_item_id AND ORGANIZATION_ID = p_organization_id
186: AND MSI.ITEM_TYPE = LOOKUP.LOOKUP_CODE(+)
187: AND LOOKUP.LOOKUP_TYPE(+) = 'ITEM_TYPE'

Line 545: FROM mtl_system_items

541: --
542: **************************************************************/
543: SELECT bom_item_type
544: INTO l_Bom_comp_item_type
545: FROM mtl_system_items
546: WHERE inventory_item_id = p_component_item_id
547: AND organization_id = p_organization_id;
548:
549: SELECT process_enabled_flag

Line 1362: FROM mtl_system_items_b

1358: THEN
1359: BEGIN
1360: SELECT product_family_item_id
1361: INTO Pf_Item_Id
1362: FROM mtl_system_items_b
1363: WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
1364: AND organization_id = g_rev_comp_Unexp_rec.organization_id;
1365:
1366: If (Pf_Item_Id is NULL) THEN

Line 1620: FROM mtl_system_items

1616: SELECT DECODE(restrict_subinventories_code, 1, 'Y', 'N'),
1617: inventory_asset_flag
1618: INTO l_RestrictSubInventory,
1619: l_InventoryAsset
1620: FROM mtl_system_items
1621: WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
1622: AND organization_id = g_rev_comp_Unexp_rec.organization_id;
1623:
1624: IF l_RestrictSubInventory = 'Y' THEN

Line 1772: FROM mtl_system_items

1768:
1769: -- Get Value of Item Locator
1770: SELECT location_control_code
1771: INTO l_item_locator_control
1772: FROM mtl_system_items
1773: WHERE organization_id = g_rev_comp_Unexp_rec.organization_id
1774: AND inventory_item_id = g_rev_comp_Unexp_rec.component_item_id;
1775:
1776: -- Get if locator is restricted or unrestricted

Line 1780: FROM mtl_system_items

1776: -- Get if locator is restricted or unrestricted
1777:
1778: SELECT RESTRICT_LOCATORS_CODE
1779: INTO l_item_loc_restricted
1780: FROM mtl_system_items
1781: WHERE organization_id = g_rev_comp_Unexp_rec.organization_id
1782: AND inventory_item_id = g_rev_comp_Unexp_rec.component_item_id;
1783:
1784: --

Line 2340: FROM mtl_system_items assy,

2336: FUNCTION Check_Optional RETURN BOOLEAN
2337: IS
2338: CURSOR c_CheckOptional IS
2339: SELECT 'Valid' is_Valid
2340: FROM mtl_system_items assy,
2341: mtl_system_items comp
2342: WHERE assy.organization_id = g_rev_comp_Unexp_rec.organization_id
2343: AND assy.inventory_item_id =
2344: g_rev_comp_Unexp_rec.revised_item_id

Line 2341: mtl_system_items comp

2337: IS
2338: CURSOR c_CheckOptional IS
2339: SELECT 'Valid' is_Valid
2340: FROM mtl_system_items assy,
2341: mtl_system_items comp
2342: WHERE assy.organization_id = g_rev_comp_Unexp_rec.organization_id
2343: AND assy.inventory_item_id =
2344: g_rev_comp_Unexp_rec.revised_item_id
2345: AND comp.organization_id = g_rev_comp_Unexp_rec.organization_id

Line 2407: FROM MTL_SYSTEM_ITEMS msi

2403: g_rev_comp_Unexp_rec.bill_sequence_id
2404: AND bom.organization_id <>
2405: g_rev_comp_Unexp_rec.organization_id
2406: AND NOT EXISTS (SELECT 1
2407: FROM MTL_SYSTEM_ITEMS msi
2408: WHERE msi.organization_id =
2409: bom.organization_id
2410: AND msi.inventory_item_id =
2411: g_rev_comp_Unexp_rec.component_item_id

Line 2422: FROM MTL_SYSTEM_ITEMS msi

2418: WHERE bom.source_bill_sequence_id =
2419: g_rev_comp_Unexp_rec.bill_sequence_id
2420: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
2421: AND NOT EXISTS (SELECT 1
2422: FROM MTL_SYSTEM_ITEMS msi
2423: WHERE msi.organization_id = bom.organization_id
2424: AND msi.inventory_item_id =
2425: g_rev_comp_Unexp_rec.component_item_id
2426: );

Line 2436: FROM MTL_SYSTEM_ITEMS msi

2432: WHERE bom.source_bill_sequence_id =
2433: g_rev_comp_Unexp_rec.bill_sequence_id
2434: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
2435: AND NOT EXISTS (SELECT 1
2436: FROM MTL_SYSTEM_ITEMS msi
2437: WHERE msi.organization_id = bom.organization_id
2438: AND msi.inventory_item_id =
2439: g_rev_comp_Unexp_rec.component_item_id
2440: AND msi.bom_enabled_flag = 'Y' -- Uncommented for bug 5925020

Line 3161: FROM mtl_system_items

3157: Is_Item_PTO VARCHAR2(1) := 'N';
3158:
3159: CURSOR c_ATO_PTO IS
3160: SELECT replenish_to_order_flag, pick_components_flag
3161: FROM mtl_system_items
3162: WHERE inventory_item_id =
3163: p_rev_comp_unexp_rec.revised_item_id
3164: AND organization_id = p_rev_comp_unexp_rec.organization_id;
3165:

Line 3168: FROM mtl_system_items

3164: AND organization_id = p_rev_comp_unexp_rec.organization_id;
3165:
3166: Cursor Unit_Controlled_Item IS
3167: SELECT effectivity_control
3168: FROM mtl_system_items
3169: WHERE inventory_item_id = p_rev_comp_unexp_rec.revised_item_id
3170: AND organization_id = p_rev_comp_unexp_rec.organization_id;
3171:
3172: l_bill_to_end_number VARCHAR2(30);

Line 3317: FROM mtl_system_items assy,

3313: g_Comp_Bom_Enabled_flag,
3314: g_Comp_ATO_Forecast_Control,
3315: g_Comp_Effectivity_Control, --2044133
3316: G_Comp_Tracking_Quantity_Ind
3317: FROM mtl_system_items assy,
3318: mtl_system_items comp
3319: WHERE assy.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
3320: AND assy.inventory_item_id = g_rev_Comp_Unexp_Rec.revised_item_id
3321: AND comp.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id

Line 3318: mtl_system_items comp

3314: g_Comp_ATO_Forecast_Control,
3315: g_Comp_Effectivity_Control, --2044133
3316: G_Comp_Tracking_Quantity_Ind
3317: FROM mtl_system_items assy,
3318: mtl_system_items comp
3319: WHERE assy.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
3320: AND assy.inventory_item_id = g_rev_Comp_Unexp_Rec.revised_item_id
3321: AND comp.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
3322: AND comp.inventory_item_id = g_rev_Comp_Unexp_Rec.Component_item_id;

Line 5888: CURSOR c_Geteffcontrol IS SELECT effectivity_control FROM mtl_system_items

5884: l_assembly_item_id NUMBER;
5885: l_org_id NUMBER;
5886: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
5887:
5888: CURSOR c_Geteffcontrol IS SELECT effectivity_control FROM mtl_system_items
5889: WHERE inventory_item_id = p_rev_comp_unexp_rec.component_item_id AND
5890: organization_id = l_org_id;
5891:
5892: BEGIN

Line 6680: SELECT 'x' INTO l_dummy FROM mtl_system_items WHERE

6676: BEGIN
6677: /* Enforce_Integer can be UP only if the component item's rounding control type allows
6678: to round order quantities */
6679:
6680: SELECT 'x' INTO l_dummy FROM mtl_system_items WHERE
6681: inventory_item_id = p_rev_comp_unexp_rec.component_item_id
6682: AND organization_id = p_rev_comp_unexp_rec.organization_id
6683: AND rounding_control_type = 1;
6684:

Line 7089: FROM mtl_system_items

7085: AND acd_type = 3;
7086:
7087: CURSOR c_Check_Unit_Effective IS
7088: SELECT effectivity_control
7089: FROM mtl_system_items
7090: WHERE inventory_item_id = p_component_item_id
7091: AND organization_id = p_organization_id;
7092:
7093:

Line 7105: FROM mtl_system_items

7101: --
7102: ***********************************************************/
7103: SELECT bom_item_type
7104: INTO l_rev_comp_item_type
7105: FROM mtl_system_items
7106: WHERE inventory_item_id = p_component_item_id
7107: AND organization_id = p_organization_id;
7108:
7109: IF l_rev_comp_item_type NOT IN

Line 7902: FROM mtl_system_items assy,

7898: l_Assy_PTO_flag,
7899: l_Comp_Item_Type,
7900: l_Comp_ATO_flag,
7901: l_Comp_Config
7902: FROM mtl_system_items assy,
7903: mtl_system_items comp
7904: WHERE assy.organization_id = p_assembly_org_id
7905: AND assy.inventory_item_id = p_assembly_item_id
7906: AND comp.organization_id = p_comp_org_id

Line 7903: mtl_system_items comp

7899: l_Comp_Item_Type,
7900: l_Comp_ATO_flag,
7901: l_Comp_Config
7902: FROM mtl_system_items assy,
7903: mtl_system_items comp
7904: WHERE assy.organization_id = p_assembly_org_id
7905: AND assy.inventory_item_id = p_assembly_item_id
7906: AND comp.organization_id = p_comp_org_id
7907: AND comp.inventory_item_id = p_comp_item_id;