APPS.OE_CONFIG_PVT dependencies on MTL_SYSTEM_ITEMS

Line 666: FROM MTL_SYSTEM_ITEMS_KFV

662:
663: BEGIN
664: SELECT concatenated_segments
665: INTO l_concatenated_segments
666: FROM MTL_SYSTEM_ITEMS_KFV
667: WHERE inventory_item_id = config_rec.inventory_item_id
668: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN

Line 867: FROM MTL_SYSTEM_ITEMS_KFV

863:
864: BEGIN
865: SELECT concatenated_segments
866: INTO l_concatenated_segments
867: FROM MTL_SYSTEM_ITEMS_KFV
868: WHERE inventory_item_id = config_rec.inventory_item_id
869: AND organization_id = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
870: EXCEPTION
871: WHEN NO_DATA_FOUND THEN

Line 2313: FROM mtl_system_items

2309: l_ato_line_id <> l_line_id THEN
2310:
2311: SELECT INDIVISIBLE_FLAG
2312: INTO l_indivisible_flag
2313: FROM mtl_system_items
2314: WHERE inventory_item_id = l_child_inv_item_id
2315: AND organization_id =
2316: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
2317:

Line 2810: FROM mtl_system_items

2806: LENGTH( OEATO.COMPONENT_CODE )
2807: )
2808: AND OEATO.inventory_item_id =
2809: ( SELECT inventory_item_id
2810: FROM mtl_system_items
2811: WHERE inventory_item_id =
2812: OEATO.inventory_item_id
2813: AND organization_id =
2814: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')

Line 2827: FROM mtl_system_items

2823: SUBSTR( OEOPT.COMPONENT_CODE, 1,
2824: LENGTH( OEMIN.COMPONENT_CODE ))
2825: AND OEMIN.inventory_item_id =
2826: ( SELECT inventory_item_id
2827: FROM mtl_system_items
2828: WHERE inventory_item_id =
2829: OEMIN.inventory_item_id
2830: AND organization_id =
2831: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')