DBA Data[Home] [Help]

APPS.CSP_REPAIR_PO_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 813: From mtl_system_items_kfv MSIK

809: Cursor item_cur (P_organization_id Number,P_inventory_item_id Number) is
810: Select MSIK.concatenated_segments item_number,
811: MSIK.description item_description,
812: MSIK.primary_uom_code
813: From mtl_system_items_kfv MSIK
814: Where MSIK.organization_id = P_organization_id
815: and MSIK.inventory_item_id = P_inventory_item_id
816: and sysdate between nvl(MSIK.start_date_active,sysdate)
817: and nvl(MSIK.end_date_active,sysdate);