[Home] [Help]
150: , X_Organization_ID NUMBER
151: , X_Item_ID NUMBER
152: , X_Category_ID NUMBER ) IS
153: SELECT concatenated_segments , description
154: FROM mtl_system_items_b_kfv
155: WHERE organization_id = X_Organization_ID
156: AND inventory_item_id = X_Item_ID
157: AND X_Transfer_Mode = PJM_MASS_TRANSFER_PUB.G_TXFR_MODE_ONE_ITEM
158: UNION ALL