setVapiConfig('oa', $_SESSION['S_USERID']); if ($nav_upc) { $sql = 'SELECT o.onesheet_id, v.vendor_id FROM onesheet o INNER JOIN releases r ON o.upc = r.upc INNER JOIN artist_info a ON a.artist_id = r.artist_id INNER JOIN vendor v ON v.vendor_id = a.vendor_id WHERE r.upc = ?'; $os_result = $pdoWrapperObj->executeQuery($sql, [$nav_upc]); if ($os_result === false) { show_pdo_error($sql, $pdoWrapperObj->getLastStatement()); } // This query retrieves the display_upc from releases table using upc to display it in link's $sql = 'SELECT r.display_upc, r.release_id, v.vendor_id, v.is_distributor, r.product_type_id, r.upc FROM releases r LEFT JOIN artist_info a ON a.artist_id = r.artist_id LEFT JOIN vendor v ON v.vendor_id = a.vendor_id WHERE r.upc = ?'; $sql_result = $pdoWrapperObj->executeQuery($sql, [$nav_upc]); if ($sql_result === false) { show_pdo_error($sql, $pdoWrapperObj->getLastStatement()); } $result_row = $sql_result[0]; $display_upc = $result_row['display_upc']; $non_display_upc = $result_row['upc']; $releaseStatusPage = "individual_upc_overall"; ?>

• Onesheet
• Release Status
• Generate Metadata Update
• Manage Pricing
• Manage Instant Grats
• Manage Localization
• ">Open Rejection
• "> Projections
• Listening Notes
• ">Sales Sheets
• Listening Notes