DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 806: From mtl_system_items_kfv MSIK

802: Cursor item_cur (P_organization_id Number,P_inventory_item_id Number) is
803: Select MSIK.concatenated_segments item_number,
804: MSIK.description item_description,
805: MSIK.primary_uom_code
806: From mtl_system_items_kfv MSIK
807: Where MSIK.organization_id = P_organization_id
808: and MSIK.inventory_item_id = P_inventory_item_id
809: and sysdate between nvl(MSIK.start_date_active,sysdate)
810: and nvl(MSIK.end_date_active,sysdate);