DBA Data[Home] [Help]

APPS.INV_TRANSACTION_LOVS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 93: from mtl_system_items_kfv

89: select concatenated_segments, inventory_item_id, description,
90: revision_qty_control_code, lot_control_code, location_control_code,
91: serial_number_control_code, restrict_subinventories_code,
92: restrict_locators_code
93: from mtl_system_items_kfv
94: where organization_id = p_organization_id
95: and mtl_transactions_enabled_flag = 'Y'
96: and concatenated_segments like p_concatenated_segments;
97: END;

Line 119: from mtl_system_items_kfv

115: restrict_locators_code ,
116: Nvl(shelf_life_code, 1),
117: Nvl(shelf_life_days,0),
118: Nvl(effectivity_control,1)
119: from mtl_system_items_kfv
120: where organization_id = p_Organization_Id
121: and mtl_transactions_enabled_flag = 'Y'
122: and inventory_item_id IN
123: (SELECT inventory_item_id

Line 134: from mtl_system_items_kfv

130: select concatenated_segments,inventory_item_id,description,
131: revision_qty_control_code,lot_control_code,
132: serial_number_control_code,restrict_subinventories_code,restrict_locators_code,
133: location_control_code,Nvl(shelf_life_code, 1),Nvl(shelf_life_days,0), Nvl(effectivity_control,1)
134: from mtl_system_items_kfv
135: where organization_id = p_Organization_Id
136: and mtl_transactions_enabled_flag = 'Y'
137: and concatenated_segments like p_Concatenated_Segments;
138: END IF;