APPS.OE_CONFIG_PVT dependencies on MTL_SYSTEM_ITEMS

Line 678: FROM MTL_SYSTEM_ITEMS_KFV

674:
675: BEGIN
676: SELECT concatenated_segments
677: INTO l_concatenated_segments
678: FROM MTL_SYSTEM_ITEMS_KFV
679: WHERE inventory_item_id = config_rec.inventory_item_id
680: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
681: EXCEPTION
682: WHEN NO_DATA_FOUND THEN

Line 879: FROM MTL_SYSTEM_ITEMS_KFV

875:
876: BEGIN
877: SELECT concatenated_segments
878: INTO l_concatenated_segments
879: FROM MTL_SYSTEM_ITEMS_KFV
880: WHERE inventory_item_id = config_rec.inventory_item_id
881: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN

Line 2415: FROM mtl_system_items

2411: l_ato_line_id <> l_line_id THEN
2412:
2413: SELECT INDIVISIBLE_FLAG
2414: INTO l_indivisible_flag
2415: FROM mtl_system_items
2416: WHERE inventory_item_id = l_child_inv_item_id
2417: AND organization_id =
2418: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2419:

Line 3237: FROM mtl_system_items

3233: LENGTH( OEATO.COMPONENT_CODE )
3234: )
3235: AND OEATO.inventory_item_id =
3236: ( SELECT inventory_item_id
3237: FROM mtl_system_items
3238: WHERE inventory_item_id =
3239: OEATO.inventory_item_id
3240: AND organization_id =
3241: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')

Line 3254: FROM mtl_system_items

3250: SUBSTR( OEOPT.COMPONENT_CODE, 1,
3251: LENGTH( OEMIN.COMPONENT_CODE ))
3252: AND OEMIN.inventory_item_id =
3253: ( SELECT inventory_item_id
3254: FROM mtl_system_items
3255: WHERE inventory_item_id =
3256: OEMIN.inventory_item_id
3257: AND organization_id =
3258: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')