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 1354: FROM mtl_system_items_b

1350: THEN
1351: BEGIN
1352: SELECT product_family_item_id
1353: INTO Pf_Item_Id
1354: FROM mtl_system_items_b
1355: WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
1356: AND organization_id = g_rev_comp_Unexp_rec.organization_id;
1357:
1358: If (Pf_Item_Id is NULL) THEN

Line 1612: FROM mtl_system_items

1608: SELECT DECODE(restrict_subinventories_code, 1, 'Y', 'N'),
1609: inventory_asset_flag
1610: INTO l_RestrictSubInventory,
1611: l_InventoryAsset
1612: FROM mtl_system_items
1613: WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
1614: AND organization_id = g_rev_comp_Unexp_rec.organization_id;
1615:
1616: IF l_RestrictSubInventory = 'Y' THEN

Line 1764: FROM mtl_system_items

1760:
1761: -- Get Value of Item Locator
1762: SELECT location_control_code
1763: INTO l_item_locator_control
1764: FROM mtl_system_items
1765: WHERE organization_id = g_rev_comp_Unexp_rec.organization_id
1766: AND inventory_item_id = g_rev_comp_Unexp_rec.component_item_id;
1767:
1768: -- Get if locator is restricted or unrestricted

Line 1772: FROM mtl_system_items

1768: -- Get if locator is restricted or unrestricted
1769:
1770: SELECT RESTRICT_LOCATORS_CODE
1771: INTO l_item_loc_restricted
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: --

Line 2332: FROM mtl_system_items assy,

2328: FUNCTION Check_Optional RETURN BOOLEAN
2329: IS
2330: CURSOR c_CheckOptional IS
2331: SELECT 'Valid' is_Valid
2332: FROM mtl_system_items assy,
2333: mtl_system_items comp
2334: WHERE assy.organization_id = g_rev_comp_Unexp_rec.organization_id
2335: AND assy.inventory_item_id =
2336: g_rev_comp_Unexp_rec.revised_item_id

Line 2333: mtl_system_items comp

2329: IS
2330: CURSOR c_CheckOptional IS
2331: SELECT 'Valid' is_Valid
2332: FROM mtl_system_items assy,
2333: mtl_system_items comp
2334: WHERE assy.organization_id = g_rev_comp_Unexp_rec.organization_id
2335: AND assy.inventory_item_id =
2336: g_rev_comp_Unexp_rec.revised_item_id
2337: AND comp.organization_id = g_rev_comp_Unexp_rec.organization_id

Line 2399: FROM MTL_SYSTEM_ITEMS msi

2395: g_rev_comp_Unexp_rec.bill_sequence_id
2396: AND bom.organization_id <>
2397: g_rev_comp_Unexp_rec.organization_id
2398: AND NOT EXISTS (SELECT 1
2399: FROM MTL_SYSTEM_ITEMS msi
2400: WHERE msi.organization_id =
2401: bom.organization_id
2402: AND msi.inventory_item_id =
2403: g_rev_comp_Unexp_rec.component_item_id

Line 2414: FROM MTL_SYSTEM_ITEMS msi

2410: WHERE bom.source_bill_sequence_id =
2411: g_rev_comp_Unexp_rec.bill_sequence_id
2412: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
2413: AND NOT EXISTS (SELECT 1
2414: FROM MTL_SYSTEM_ITEMS msi
2415: WHERE msi.organization_id = bom.organization_id
2416: AND msi.inventory_item_id =
2417: g_rev_comp_Unexp_rec.component_item_id
2418: );

Line 2428: FROM MTL_SYSTEM_ITEMS msi

2424: WHERE bom.source_bill_sequence_id =
2425: g_rev_comp_Unexp_rec.bill_sequence_id
2426: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
2427: AND NOT EXISTS (SELECT 1
2428: FROM MTL_SYSTEM_ITEMS msi
2429: WHERE msi.organization_id = bom.organization_id
2430: AND msi.inventory_item_id =
2431: g_rev_comp_Unexp_rec.component_item_id
2432: AND msi.bom_enabled_flag = 'Y' -- Uncommented for bug 5925020

Line 3126: FROM mtl_system_items

3122: Is_Item_PTO VARCHAR2(1) := 'N';
3123:
3124: CURSOR c_ATO_PTO IS
3125: SELECT replenish_to_order_flag, pick_components_flag
3126: FROM mtl_system_items
3127: WHERE inventory_item_id =
3128: p_rev_comp_unexp_rec.revised_item_id
3129: AND organization_id = p_rev_comp_unexp_rec.organization_id;
3130:

Line 3133: FROM mtl_system_items

3129: AND organization_id = p_rev_comp_unexp_rec.organization_id;
3130:
3131: Cursor Unit_Controlled_Item IS
3132: SELECT effectivity_control
3133: FROM mtl_system_items
3134: WHERE inventory_item_id = p_rev_comp_unexp_rec.revised_item_id
3135: AND organization_id = p_rev_comp_unexp_rec.organization_id;
3136:
3137: l_bill_to_end_number VARCHAR2(30);

Line 3281: FROM mtl_system_items assy,

3277: g_Comp_Bom_Enabled_flag,
3278: g_Comp_ATO_Forecast_Control,
3279: g_Comp_Effectivity_Control, --2044133
3280: G_Comp_Tracking_Quantity_Ind
3281: FROM mtl_system_items assy,
3282: mtl_system_items comp
3283: WHERE assy.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
3284: AND assy.inventory_item_id = g_rev_Comp_Unexp_Rec.revised_item_id
3285: AND comp.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id

Line 3282: mtl_system_items comp

3278: g_Comp_ATO_Forecast_Control,
3279: g_Comp_Effectivity_Control, --2044133
3280: G_Comp_Tracking_Quantity_Ind
3281: FROM mtl_system_items assy,
3282: mtl_system_items comp
3283: WHERE assy.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
3284: AND assy.inventory_item_id = g_rev_Comp_Unexp_Rec.revised_item_id
3285: AND comp.organization_id = g_rev_Comp_Unexp_Rec.Organization_Id
3286: AND comp.inventory_item_id = g_rev_Comp_Unexp_Rec.Component_item_id;

Line 5649: CURSOR c_Geteffcontrol IS SELECT effectivity_control FROM mtl_system_items

5645: l_assembly_item_id NUMBER;
5646: l_org_id NUMBER;
5647: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
5648:
5649: CURSOR c_Geteffcontrol IS SELECT effectivity_control FROM mtl_system_items
5650: WHERE inventory_item_id = p_rev_comp_unexp_rec.component_item_id AND
5651: organization_id = l_org_id;
5652:
5653: BEGIN

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

6437: BEGIN
6438: /* Enforce_Integer can be UP only if the component item's rounding control type allows
6439: to round order quantities */
6440:
6441: SELECT 'x' INTO l_dummy FROM mtl_system_items WHERE
6442: inventory_item_id = p_rev_comp_unexp_rec.component_item_id
6443: AND organization_id = p_rev_comp_unexp_rec.organization_id
6444: AND rounding_control_type = 1;
6445:

Line 6850: FROM mtl_system_items

6846: AND acd_type = 3;
6847:
6848: CURSOR c_Check_Unit_Effective IS
6849: SELECT effectivity_control
6850: FROM mtl_system_items
6851: WHERE inventory_item_id = p_component_item_id
6852: AND organization_id = p_organization_id;
6853:
6854:

Line 6866: FROM mtl_system_items

6862: --
6863: ***********************************************************/
6864: SELECT bom_item_type
6865: INTO l_rev_comp_item_type
6866: FROM mtl_system_items
6867: WHERE inventory_item_id = p_component_item_id
6868: AND organization_id = p_organization_id;
6869:
6870: IF l_rev_comp_item_type NOT IN